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

110 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
wreathen1425614(None) 
wreathe13339051wreathe_
wreathed15257461wreathed
wreather14268601wreather
wreathes14299891wreathes
breathe123711842breathe_
breathed14469642breathed
breather133610592breather
breathes134212902breathes
greaten83610642great_en
heathen133410892_heathen
weather133513222w_eather
wheaten1336402wheat_en
wrathed14298522wr_athed
wreath124111192wreath__
wreathers15257492wreathers
wreathing16266312wreathing
wreaths13338372wreath_s
wreathy16326062wreath_y
writhen13407862wr_ithen
aweather1434263aweather
beaten84617063_beat_en
breached163411643breached
breacher153011503breacher
breaches153714123breaches
breath113916263breath__
breathers14319103breathers
breathier1435383breathier
breathing15218373breathing
breaths124411183breath_s
breathy15328033breath_y
brethren1343783bre_thren
create85126383creat_e_
created104323453creat_ed
creates95225203creat_es
creatin93618133creat_in
creatine103417413creatine
creation102816513creation
earthen1039253__earthen
eaten55323053__eat_en
enwreathe1552863enwreathe_
enwreathed1752313enwreathed
enwreathes1662663enwreathes
feather133613503_feather
freshen133010883fre_shen
greatens9307593great_ens
greater84416493great_er
greyhen1443193gre_yhen
heathens143210153_heathens
heather133914853_heather
leather103815783_leather
leathern11398913_leathern
meatmen1138243_meatmen
neaten64214543_neat_en
peahen113410133_pea_hen
pleather1356653pleather
preached163412063preached
preacher153211373preacher
preaches153214893preaches
preteen939873pre_teen
rathe85821923_r_athe_
rather94319743_r_ather
ratten64217383_r_atten
reached134619083_reached
reacher123718293_reacher
reaches123423203_reaches
regather1236733_regather
retaken113911803_retaken
sheathe1348993sheathe_
sheathed1547223sheathed
sheather1458233sheather
sheathes14610193sheathes
threaten1146303threat_en
treated83618703treat_ed
treater74219833treat_er
treaties8316983treaties
treatment1148183treatment
uneaten7412543uneat_en
unwreathe1564423unwreathe_
unwreathed1763683unwreathed
unwreathes1673293unwreathes
urethan1045473ure_than
weaken13349603w_ea_ken
weathers143412833w_eathers
wether123315393w_e_ther
wheatens1454663wheat_ens
whether16346623whe_ther
wrath115715873wr_ath__
wrathier1435903wr_athier
wrathing15248923wr_athing
wraths123810083wr_ath_s
wrathy15377853wr_ath_y
wreaked15369023wrea_ked
wreaker143610043wrea_ker
wrenched17748133wrenched
wrencher16287783wrencher
wrenches163210233wrenches
wrested113410933wrest_ed
wrester102812413wrest_er
wrestle10298843wrestle_
wrestled12296763wrestled
wrestler11306993wrestler
wrestles113310063wrestles
wretched17276533wretched
wretches16257283wretches
writhe125310703wr_ithe_
writhed14389623wr_ithed
writher134010853wr_ither
writhes134811703wr_ithes
written10336343wr_itten

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.423422437.4
2DLD Change Limit1461621107.65619091.2
3Display Results1101100.0462391.3
 (SQL Overall)1786911108.12521992.7
 
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.