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 “wreathy” 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.

134 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
wreathy1632606(None) 
breathy15328031breathy
wrathy15377851wr_athy
wreath124111191wreath_
wreathe13339051wreathe
wreaths13338371wreaths
breath113916262breath_
breathe123711842breathe
breaths124411182breaths
deathy134210232_deathy
greatly1137612greatly
heathy156111212_heathy
preachy17307312preachy
treaty94414352treat_y
wealthy16314332w_ealthy
wrath115715872wr_ath_
wraths123810082wr_aths
wreathed15257462wreathed
wreathen14256142wreathen
wreather14268602wreather
wreathes14299892wreathes
apathy1437033_apathy
areally10411243areally
areaway1335913areaway
beachy164011253_beachy
brashy145210593br_ashy
bratty1159683br_atty
breach134213723breach_
breadth1365993breadth_
breadths1474463breadths
bready124511183brea_dy
breathed14469643breathed
breather133610593breather
breathes134212903breathes
breathily1744063breathily
brothy14519623br_othy
creaky154911553crea_ky
creamy134811363crea_my
creasy114612303crea_sy
create85126383creat_e
created104323453created
creates95225203creates
creatin93618133creatin
creator93714443creator
death94822523_death_
deathly14336863_deathly
deaths105914443_deaths
dreamy12509993drea_my
dreary104611673drea_ry
drouthy14395173drouthy
earthy12399943__earthy
eath75735663__eath_
empathy1743483empathy
enwreathe1552863enwreathe
erectly1257483erectly
featly123711753_featly
freaky16439233frea_ky
fretty1249223fre_tty
frothy15578373fr_othy
greasy10419463grea_sy
great66034243great__
greaten83610643greaten
greater84416493greater
greats76318393great_s
growthy1773283growthy
healthy16416083_healthy
heath115724283_heath_
heaths126316383_heaths
lathy115215063__lathy
leachy14419733_leachy
meaty107021313_meat_y
neath86020283_neath_
neatly93812483_neatly
peachy164510843_peachy
peaty105725693_peat_y
preach133613923preach_
pretty11510873pre_tty
rath76037663_r_ath_
rathe85821923_r_athe
ratty84819593_r_atty
reach105123883_reach_
ready94821503_rea_dy
really93315613_really
realty92713693_realty
reata54225393_reat_a
reatas64021013_reatas
reechy14367823_reechy
retry84718083_re_try
sheath12412893sheath_
sheathe1348993sheathe
sheaths1358753sheaths
stealthy14103063stealthy
sweaty123710053sweat_y
trashy12509053tr_ashy
treacly1237093treacly
treat56240353treat__
treated83618703treated
treater74219833treater
treats64821693treat_s
unwreathe1564423unwreathe
warpath1545203warpath_
warpaths1643973warpaths
washy145911843w__ashy
weakly1636483w_eakly
wealth12379223w_ealth_
wealths13365813w_ealths
weary115620613w_ea_ry
weather133513223w_eather
wetly114511713w_e_tly
wheat114924573wheat__
wheaten1336403wheaten
wheats125013223wheat_s
withy144813763w__ithy
worthy15598803w_orthy
wraith1258603wraith_
wraiths1355033wraiths
wrathed14298523wr_athed
wrathily1744773wr_athily
wreak125513273wrea__k
wreaked15369023wreaked
wreaker143610043wreaker
wreaks134711113wrea_ks
wreathers15257493wreathers
wreathing16266313wreathing
wrench14439353wrench_
wrest84925433wrest__
wrested113410933wrested
wrester102812413wrester
wrestle10298843wrestle
wrests95313083wrest_s
wretch14326533wre_tch
wristy12509703wrist_y
writhe125310703wr_ithe
wroth116815883wr_oth_

Search took 7 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 Filter1786911340270.393454684.5
2DLD Change Limit1340271346.39020974.5
3Display Results1341340.0462913.0
 (SQL Overall)1786911346.82926166.5
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2025  |  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.