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

156 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
witherer1418795(None) 
ditherer12187761ditherer
withered15169431withered
witherers15146841witherers
bitterer10309772bitterer
cipherer1545572cipherer
dithered13189292dithered
ditherers13196682ditherers
gatherer12147902gatherer
latherer111310442latherer
litterer82810172litterer
miterer92511332mit_erer
swithered16135462swithered
titterer8268522titterer
twitterer1243302twitterer
waterer103314072wat_erer
winterer112110442winterer
withdrew1842472withdrew
wither124321352with__er
witherod15156152witherod
withers134417752wither_s
withier132910492with_ier
wuthered15157432wuthered
adherer1137563_adherer
alterer72713993alt_erer
batterer102713213batterer
bickerer16106773bickerer
bittered112711833bittered
blatherer14176713blatherer
blithered15156123blithered
bothered142110393bothered
butcherer1643753butcherer
caterer92815943cat_erer
catheter1338153catheter
ciphered1637053ciphered
cipherers1644893cipherers
cither114616683cith__er
cithern12489913cither_n
citherns13338873citherns
cithers124315773cither_s
cithren12306593cith_ren
coherer122912783_coherer
dither104417683dith__er
dithers114016153dither_s
dithery14318943dither_y
either94517423eith__er
enterer72015633ent_erer
fathered151510433fathered
fetterer11207813fetterer
filterer11258143filterer
fingerer12127223fingerer
fritterer12234403fritterer
furtherer1543813furtherer
gathered13149373gathered
gatherers13156883gatherers
hinderer1238273hinderer
hither124417253hith__er
hitherto1444353hitherto
inhere9313713_inhere_
inhered11313163_inhered
inheres10315173_inheres
ither84617603_ith__er
jittered16267223jittered
jitterier1644433jitterier
kipperer16294723kipperer
lathered121512323lathered
latherers12158853latherers
letterer8259223letterer
limberer12187053limberer
lingerer9118303lingerer
lither94520953lith__er
littered92511383littered
litterers9228193litterers
loiterer837083loit_erer
mitered103213233mit_ered
miterers10219683mit_erers
mither114218563mith__er
mithers123516733mither_s
mothered142310103mothered
mutterer10218913mutterer
patterer103112173patterer
pilferer1344923pilferer
pithier123010293pith_ier
pothered142311043pothered
potterer102310263potterer
putterer10209913putterer
silverer11216733silverer
simperer1237173simperer
sincerer1037203sincerer
slithered13136623slithered
smotherer1444633smotherer
steerer73113633_steerer
swither133710993swith__er
swithers144310533swither_s
tethered1238493tethered
there87527393__there_
theres96525473__theres
tinkerer1286803tinkerer
tither94920283tith__er
tithers104216733tither_s
tittered9239493tittered
titterers9236993titterers
totterer8217793totterer
twittered1333813twittered
twitterers1342673twitterers
utterer71910463_utterer
wagerer11328493w_agerer
waitered1238753wait_ered
wanderer122210123wanderer
watered113014953wat_ered
waterers112312783wat_erers
waterier11312083wat_erier
waverer13319523w_averer
weathered16168513weathered
wether123315393weth__er
wethers135214693wether_s
where117019423w__here_
wheres125917433w__heres
whichever2341903whichever
whimperer19123723whimperer
whisperer17133693whisperer
whitener1435733whit_ener
whither163510253whith__er
wickeder1843983wickeder
widener11318693wi_dener
wiener94513543wi__ener
wildered1336633wildered
wintered122111573wintered
winterers12209723winterers
winterier1238333winterier
wirer85124953wi___rer
wisher123617063wish__er
wishers133215213wisher_s
witcheries1845463witcheries
witchery19236093witcher_y
witchier16307883witchier
withdraw1843313withdraw
withe115220233with__e_
withed134416233with__ed
withering16108813withering
witherite1546693witherite
witherites1645973witherites
witherods16145443witherods
withes124620843with__es
withies133913543with_ies
witnesser12224533witnesser
wittier103910823wit_tier
wonderer12249183wonderer
writher134010853writh__er
writhers14398983writher_s
wuther124511613wuth__er
wuthers133711523wuther_s
zither183813083zith__er
zithern19447023zither_n
zitherns20376133zitherns
zithers193911973zither_s

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.1731032896.0
2DLD Change Limit1461621567.92018454.8
3Display Results1561560.0632476.2
 (SQL Overall)1786911568.15621909.1
 
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.