Welcome!   |  Search Scrabble® Dictionary using DLD   |  Statistics   |  Compare any two Strings using DLD   |  Reference   |  Your IP

Dictionary Search Results using Damerau-Levenshtein distance in T-SQL

Here are the results of your fuzzy-string dictionary search for “wreather” with Change Limit: [1] [2] [3]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

234 similar words found! Changes to Transform each Found Word to your word are shown as:
 remove a letter ~ replace a letter ~ swap two letters ~ _add a letter from your word
(Use the links in the Changes column to see more Transformation details.)

Found WordScrabble ScoreSearched PreviouslyFound PreviouslyChangesTo Transform to your Word
wreather1426860(None) 
breather133610591breather
weather133513221w_eather
wreathe13339051wreathe_
wreathed15257461wreathed
wreathen14256141wreathen
wreathers15257481wreathers
wreathes14299891wreathes
aweather1434262aweather
breacher153011502breacher
breathe123711842breathe_
breathed14469642breathed
breathers14319092breathers
breathes134212902breathes
breathier1435382breathier
feather133613502_feather
greater84416492great_er
heather133914852_heather
leather103815782_leather
pleather1356652pleather
preacher153211372preacher
rather94319732_r_ather
reacher123718292_reacher
regather1236732_regather
sheather1458212sheather
treater74219832treat_er
weathers143412832w_eathers
wether123315392w_e_ther
whether16346622whe_ther
wrathed14298522wr_athed
wrathier1435902wr_athier
wreaker143610042wrea_ker
wreath124111192wreath__
wreaths13338372wreath_s
wreathy16326062wreath_y
wrencher16287782wrencher
wrester102812412wrest_er
wrestler11306992wrestler
writher134010852wr_ither
aether94213673_ae_ther
bather115322513__bather
beater84729393_beat_er
blather125314203_blather
bleacher15358883bleacher
bleater94515303bleat_er
blether12459913ble_ther
brasher124515233br_asher
breached163411643breached
breachers16369853breachers
breaches153714113breaches
breaker133912923brea_ker
breath113916263breath__
breaths124411183breath_s
breathy15328033breath_y
broacher15329263broacher
brother123311333br_other
cheater124816953cheat_er
crasher124616153cr_asher
crater85026633cr_at_er
creakier14328333creakier
creamer113714083crea_mer
creamier12319063creamier
creaser94415723crea_ser
creasier103210193creasier
create85126373creat_e_
created104323443creat_ed
creates95225173creat_es
creator93714433creat_or
creature1038723creature
diether1147443die_ther
dreamer104110843drea_mer
dreamier11287293dreamier
drearier9297923drearier
drencher14257213drencher
eater54639843__eat_er
either94517423__either
enwreathe1552863enwreathe_
enwreathed1752313enwreathed
enwreathes1662663enwreathes
erecter93113393erect_er
ether84518773__e_ther
father125116713__father
feater95224053_feat_er
feathers143513243_feathers
feathery17368073_feathery
forefather1943573forefather
foregather1743663foregather
forgather1643663forgather
frater94520593fr_at_er
freakier15246483freakier
fresher132612643fre_sher
fretter103412753fre_tter
frettier1156593frettier
frother133110153fr_other
gather104115853__gather
grater74625433gr_at_er
greaser83913083grea_ser
greasier9298083greasier
greaten83610643great_en
greeter82812673greet_er
heater94828303_heat_er
heathen133410893_heathen
heathers143914733_heathers
heathery17349083_heathery
heathier1438343_heathier
ingather1244763ingather
irater65218343ir_at_er
krater104014313kr_at_er
kreutzer2141273kreutzer
lather95124353__lather
leacher124014843_leacher
leathern11398913_leathern
leathers114215083_leathers
leathery14438973_leathery
loather103711003_loather
meatier93214613_meatier
neater64424313_neat_er
neatherd12107193_neatherd
neither1037573_neither
nether94014163_ne_ther
peacher144216073_peacher
peatier94017233_peatier
pleater93916333pleat_er
pleathers1446453pleathers
prater84825353pr_at_er
preached163412063preached
preachers16339573preachers
preaches153214893preaches
preachier1646923preachier
prealter1048863prealter
preaver121011613prea_ver
prester93519623prest_er
prettier1069043prettier
rasher95024113_r_asher
rater54943283_r_at_er
rathe85821923_r_athe_
ratter64326313_r_atter
reached134619083_reached
reachers133515723_reachers
reaches123423203_reaches
reader73628293_rea_der
readier83117423_readier
realer63528593_rea_ler
realter73716313_realter
reamer84325213_rea_mer
reaper84223143_rea_per
rearer64928913_rea_rer
reaver94524733_rea_ver
rebater93517903_rebat_er
regathers1336333_regathers
relater73723143_relat_er
renter64527413_rent_er
rentier73618223_rentier
rester63832433_rest_er
retaker113714313_retaker
reutter71010093_reutter
seater64534153_seat_er
sheathe1348983sheathe_
sheathed1547213sheathed
sheathers1557543sheathers
sheathes14610183sheathes
slather103816063_slather
swather134213593_swather
sweater103712723sweat_er
sweatier1147033sweatier
teacher123714833_teacher
teether10349693_teether
tether93716103_te_ther
theater104014253theat_er
trasher104416123tr_asher
treachery1744693treachery
treader84113823trea_der
treadler936853treadler
treated83618703treat_ed
treaters83615823treat_ers
treaties8316983treaties
trencher13279313trencher
unwreathe1564423unwreathe_
unwreathed1763683unwreathed
unwreathes1673293unwreathes
upgather14152753upgather
ureter6313203ure_t_er
washer124720393w__asher
watcher153113403w__atcher
water84733313w__at_er
watter93221983w__atter
weaker134015443w_ea_ker
wealthier1543263w_ealthier
weaner93816773w_ea_ner
wearer94319403w_ea_rer
wearier103613283w_earier
weathered16168513w_eathered
weatherly1844403w_eatherly
weaver123916613w_ea_ver
weigher14136343w_eigher
welcher15319393w_elcher
welsher13377443w_elsher
welter93417383w_elt_er
wencher153811133w_encher
wester94222893w_est_er
wethers135214693w_e_thers
wetter93919443w_e_tter
wheatear1442563wheatear
wheaten1336403wheat_en
whetter13348803whe_tter
whither163510253w_hither
wither124321353w__ither
wrapper14368333wr_apper
wrath115715873wr_ath__
wraths123810083wr_ath_s
wrathy15377853wr_ath_y
wreaked15369023wrea_ked
wreakers15328423wrea_kers
wreathing16266313wreathing
wrecker16367603wre_cker
wrenched17748133wrenched
wrenchers17256333wrenchers
wrenches163210233wrenches
wrested113410933wrest_ed
wresters112711733wrest_ers
wrestle10298843wrestle_
wrestled12296763wrestled
wrestlers12306103wrestlers
wrestles113310063wrestles
wretched17276533wretched
wretches16257283wretches
wristier1136863wristier
writer94416513wr_it_er
writhe125310703wr_ithe_
writhed14389623wr_ithed
writhen13407863wr_ithen
writhers14398983wr_ithers
writhes134811703wr_ithes
wuther124511613w__uther

Search took 9 seconds overall (including website activity, plus SQL activity in the following phases):

  1. Length Filter: Limit the application of DLD to words with length difference of no more than the Change Limit.
  2. DLD Change Limit: Apply DLD to each remaining word, limiting each comparison according to the Change Limit.
  3. Display Results: Return the results, with similar words marked up to highlight differences.
SeqSearch PhaseWords CheckedWords MatchedSecondsWords Per Sec
1Length Filter1786911461620.1561145455.1
2DLD Change Limit1461622347.73318901.1
3Display Results2342340.0763078.9
 (SQL Overall)1786912347.96522434.5
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  Published At: SQLServerCentral (with Source Code)  |  Presented At: SQLSaturday #144  |  Demonstrated For: Sacramento SQL Server User Group  |  Developed For: Repo Remarketing  |  Running On: Microsoft SQL 2014 RTM Standard on Server 2012 R2 (also successfully run on SQL 2012 Web Edition, SQL Express 2008-2008R2, and SQL Server 2000-2005 Standard)  |  SQL Performance Monitoring By: Confio Ignite  |  American Scrabble® Dictionary From: Internet Scrabble Club  |  Scrabble® is a registered trademark. All intellectual property rights in and to the game are owned in the U.S.A and Canada by Hasbro Inc., and throughout the rest of the world by J.W. Spear & Sons Limited of Maidenhead, Berkshire, England, a subsidiary of Mattel Inc. Mattel and Spear are not affiliated with Hasbro. This site is not affiliated with Scrabble®, Mattel, Spear, or Hasbro in any way. This site is for entertainment and technical education purposes only.