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

183 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
wreathers1525749(None) 
breathers14319101breathers
weathers143412831w_eathers
wreather14268601wreather_
wreathes14299891wreathe_s
breachers16369852breachers
breather133610592breather_
breathes134212902breathe_s
feathers143513242_feathers
heathers143914732_heathers
leathers114215082_leathers
pleathers1446452pleathers
preachers16339572preachers
reachers133515722_reachers
regathers1336352_regathers
sheathers1557552sheathers
treaters83615842treat_ers
weather133513222w_eather_
wethers135214692w_e_thers
wreakers15328422wrea_kers
wreathe13339052wreathe__
wreathed15257462wreathe_d
wreathen14256142wreathe_n
wreaths13338372wreath__s
wrenchers17256332wrenchers
wresters112711732wrest_ers
wrestlers12306102wrestlers
writhers14398982wr_ithers
aethers103614943_ae_thers
aweather1434263aweather_
bathers124720363__bathers
beaters94925043_beat_ers
blathers134713793_blathers
bleachers16297923bleachers
bleaters103412323bleat_ers
blethers13429613ble_thers
breacher153011503breacher_
breaches153714123breache_s
breakers143810973brea_kers
breathe123711843breathe__
breathed14469643breathe_d
breathier1435383breathier_
breathless1543533breathless
breaths124411183breath__s
broachers16328153broachers
brothers133410833br_others
cheaters133613513cheat_ers
crashers134013233cr_ashers
craters95021893cr_at_ers
creamers124111303crea_mers
creasers103612823crea_sers
creates95225193creat_e_s
creators102814403creat_ors
creatures1138413creatures
diethers1257453die_thers
dreamers11369003drea_mers
drenchers15296103drenchers
druthers1275793dr_uthers
eaters65535953__eat_ers
enwreathes1662663enwreathe_s
erecters102611613erect_ers
ethers94518413__e_thers
fathers133916503__fathers
feather133613503_feather_
feathery17368073_feathery
forefathers2053143forefathers
foregathers1843223foregathers
forgathers1743553forgathers
fraters103517213fr_at_ers
fretters113410303fre_tters
frothers14279813fr_others
gathers114315073__gathers
graters85419743gr_at_ers
greasers93410253grea_sers
greatens9307593great_ens
greater84416493great_er_
greatness1036903greatness
greeters92610113greet_ers
heaters104225223_heat_ers
heathens143210153_heathens
heather133914853_heather_
heathery17349083_heathery
ingathers1344453ingathers
kraters114212343kr_at_ers
kreutzers2241263kreutzers
lathers104321883__lathers
leachers133712813_leachers
leather103815783_leather_
leathern11398913_leathern
leathery14438973_leathery
loathers113310443_loathers
neatherd12107193_neatherd
neatherds1395773_neatherds
peachers153213843_peachers
pleaters103613793pleat_ers
pleather1356653pleather_
praters94921653pr_at_ers
preacher153211373preacher_
preaches153214893preache_s
prealters1147773prealters
preavers13910263prea_vers
presters103419003prest_ers
rashers104020913_r_ashers
raters63936583_r_at_ers
rather94319743_r_ather_
ratters74422473_r_atters
reacher123718293_reacher_
reaches123423203_reache_s
readers83823773_rea_ders
realters83614043_realters
reamers94221083_rea_mers
reapers93520453_rea_pers
rearers74323563_rea_rers
reavers108320743_rea_vers
rebaters103413943_rebat_ers
regather1236733_regather_
relaters83218153_relat_ers
renters74224813_rent_ers
rentiers83311763_rentiers
resters74130403_rest_ers
retakers123511133_retakers
reutters8138573_reutters
seaters74028943_seat_ers
sheather1458233sheather_
sheathes14610193sheathe_s
slathers113914783_slathers
swathers144512083_swathers
sweaters113811063sweat_ers
teachers133212393_teachers
teethers11328713_teethers
tethers103815313_te_thers
theaters114211903theat_ers
trashers113013643tr_ashers
treachery1744693treachery
treaders93311843trea_ders
treadlers1045893treadlers
treater74219833treat_er_
treaties8316983treatie_s
trenchers14288073trenchers
unwreathes1673293unwreathe_s
upgathers1582533upgathers
ureters7311823ure_t_ers
washers134517523w__ashers
watchers163511793w__atchers
waters95030633w__at_ers
weaners104613833w_ea_ners
wearers104615903w_ea_rers
weathered16168513w_eathered
weatherly1844403w_eatherly
weavers133714463w_ea_vers
weighers15135673w_eighers
welchers16338053w_elchers
welshers14246813w_elshers
welters103516063w_elt_ers
wenchers16319213w_enchers
westers105221963w_est_ers
wether123315393w_e_ther_
wetters103817753w_e_tters
wheatears1542683wheatears
wheatens1454663wheat_ens
wheatless1534003wheatless
whether16346623whe_ther_
whetters14246653whe_tters
withers134417753w__ithers
wrappers15306933wr_appers
wrathed14298523wr_athe_d
wrathier1435903wr_athier_
wraths123810083wr_ath__s
wreaker143610043wrea_ker_
wreath124111193wreath___
wreathing16266313wreathing
wreathy16326063wreath__y
wreckers17315973wre_ckers
wrencher16287783wrencher_
wrenches163210233wrenche_s
wrester102812413wrest_er_
wrestler11306993wrestler_
wrestles113310063wrestle_s
wretches16257283wretche_s
writers105513493wr_it_ers
writher134010853wr_ither_
writhes134811703wr_ithe_s
wuthers133711523w__uthers

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 Filter1786911486410.1731032896.0
2DLD Change Limit1486411837.81019032.1
3Display Results1831830.1561173.1
 (SQL Overall)1786911838.13921954.9
 
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.