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

130 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
zitherns2037613(None) 
citherns13338871citherns
zithern19447021zithern_
zithers193911971zither_s
bitterns10428952bitterns
cithern12489912cithern_
cithers124315772cither_s
cithrens13355932cithrens
citterns10318122citterns
dithers114016152dither_s
gitterns9326572gitterns
lutherns1136292lutherns
mithers123516732mither_s
sithens1039382sithe_ns
tithers104216732tither_s
withers134417752wither_s
zither183813082zither__
zitherist2146602zitherist
aethers103614943aether_s
althorns1146733althorns
anthers103715203anther_s
bathers124720363bather_s
bethorns1337323bethorns
bighorns1445253bighorns
bioherms1544213bioherms
biters83925243bit_er_s
bittern94810683bittern_
bitters94920363bitter_s
blithers134711233blither_s
bothers124317753bother_s
ciphers14379993cipher_s
cisterns10369583cisterns
citers85022983cit_er_s
citharas13156723citharas
cither114616683cither__
cithren12306593cithren_
cittern9339143cittern_
cothurns1344523cothurns
diethers1257453diether_s
discerns1138163discerns
ditchers143610363ditcher_s
dither104417683dither__
dithered13189293dithered
ditherer12187763ditherer
ditherers13196683ditherers
dithering1499853dithering
dithery14318943dither_y
either94517423either__
ethers94518413_ether_s
externs1438233ext_erns
fathers133916503father_s
fishers134714723fisher_s
fitters104517753fitter_s
gathers114315073gather_s
gittern8337503gittern_
herns84825583___herns
hitchers16379993hitcher_s
hither124417253hither__
hitherto1444353hitherto
hitters104717593hitter_s
inheres10315173_inheres
interns73116773_interns
ither84617603_ither__
jitters144314473jitter_s
kitchens17195783kitche_ns
kiters105218593kit_er_s
kitharas15165413kitharas
kithes135016653kithe__s
kittens11347583kitte_ns
lathers104321883lather_s
lichens123510683liche_ns
liters65429883lit_er_s
lither94520953lither__
litters73422573litter_s
luthern1037653luthern_
miters84328783mit_er_s
mither114218563mither__
mittens9349883mitte_ns
mothers123717623mother_s
niters64624213nit_er_s
northerns1244933northerns
others93918003_other_s
patterns10439943patterns
pishers123815753pisher_s
pitchers153211483pitcher_s
pitheads14338143pitheads
pitiers93812653pitier_s
potheens13266483potheens
potherbs15387123potherbs
pothers123818623pother_s
richens12349733riche_ns
ritters74020623ritter_s
sighers113712183sigher_s
sitters74221553sitter_s
slithers114212953slither_s
smithers13369793smither_s
southerns12347213southerns
sterns64616763_st_erns
swithers144310533swither_s
terns55226873__t_erns
tethers103815313tether_s
thegns10547433__thegns
theins95015423__theins
thens85921833__the_ns
theres96525473__theres
therms115914873__therms
thorns95314103__thorns
tinhorns1145013tinhorns
titers64526413tit_er_s
titfers10318933titfer_s
tither94920283tither__
tithes94720213tithe__s
titters74219623titter_s
wethers135214693wether_s
wishers133215213wisher_s
wither124321353wither__
withered15169433withered
witherer14187953witherer
witherers15146843witherers
withering16108813withering
witherod15156153witherod
witherods16145443witherods
withes124620843withe__s
withins133511693with_ins
wiverns13366963wi_verns
writhers14398983writher_s
wuthers133711523wuther_s
zingers173514853zinger_s
zippers203310383zipper_s
zitherists2244413zitherists

Search took 8 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 Limit1461621307.06320694.0
3Display Results1301300.0632063.5
 (SQL Overall)1786911307.54923670.8
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.