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

202 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
zeolites173838(None) 
zeolite1638901zeolite_
aerolites9312582aerolites
elites66027122_e_lites
eoliths10318572_eoliths
iolites73819482_iolites
neoliths1144932neoliths
oolites72817842_oolites
pelites93821992pe_lites
penlites10312272penlites
perlites10316362perlites
velites103417302ve_lites
zeolitic1947462zeolitic
acolytes13168043acolytes
aconites10314353aconites
aerolite8315053aerolite_
aeroliths1245643aeroliths
amosites10311233amosites
anolytes11169213anolytes
aplites9314933_aplites
beelines103312803beelines
belies84631053be_li_es
bellies94023723belli_es
berlines102315453berlines
beslimes1246953beslimes
biotites10310093biotites
blites84721213__blites
boites84322703_bo_ites
boletes9316063_boletes
bolides10515073_bolides
cenobites1346203cenobites
cerites94823433ce_rites
cholates132414763cholates
cholines132214493cholines
coesites101313093coesites
colies84837053_coli_es
colitis92617353_colitis
coolies93824963cooli_es
creolises1157893creolises
creolizes2056583creolizes
cryolites1446963cryolites
dealates92716683dealates
declines113315803declines
deflates123013943deflates
defoliates1446333defoliates
delates83526283de_lates
deletes83117933de_letes
delimes10314193de_limes
dellies83622213delli_es
depletes112810643depletes
desolates10311793desolates
despites11410313despites
diorites9313523diorites
doolies83920713dooli_es
ebonites1039233ebonites
egalites9310503egalites
elates65032363_e_lates
elides74420693_e_lides
elite56230183_e_lite_
elutes64020313_e_lutes
endites83717063_endites
eolith93013903_eolit_h
eosines73718293_eosines
equites162212493_equites
evites94916473_e_vites
evolutes1156063evolutes
excites16310633_excites
fealties1139993fealties
felines104718073fe_lines
fellates11312753fellates
fellies104119743felli_es
felsites1138073felsites
ferlies103216693ferli_es
ferrites112312833ferrites
flites95122443__flites
folates103218453_folates
foliates11412753_foliates
fomites123613203_fomites
gelates83219593ge_lates
halites103221193_halites
haplites1339993haplites
helices12313723he_lices
helixes1739133he_lixes
hellkites1644633hellkites
hemlines13310623hemlines
hessites1138613hessites
holies94630033_holi_es
hoplites13310543hoplites
hyalites14208833hyalites
idolises938763idolises
idolizes1837553idolizes
illites72415013_illites
inosites8312793inosites
iolite63221983_iolite_
isolates8613513isolates
isolines8312303isolines
jellies143816533jelli_es
kaolines1239293kaolines
kellies113516853kelli_es
kernites1269113kernites
kryolites1643993kryolites
lealties8310793lealties
lenites7818443le_nites
leucites1037333leucites
marlites103415273marlites
mealies92821933meali_es
melilites1149193melilites
molies84429513_moli_es
mullites10411643mullites
negliges1034833negliges
nellies73418723nelli_es
neolith1068783neolit_h
neonates8310063neonates
niobites1037313niobites
norites74018803_norites
olives94313953__olives
oolite63319603_oolite_
ooliths10268323_ooliths
otoliths11104513otoliths
pearlites1138233pearlites
pelite84323003pe_lite_
pemolines1348623pemolines
penlite9313243penlite_
peonies93620153peoni_es
perlite9317323perlite_
petites93820203pe_tites
pisolites1149383pisolites
podites103014733_podites
polices113118053_polices
polies84034583_poli_es
polite83625073_polite_
politer92417073_politer
politest10312943_politest
polities102722343_polities
prolines102619693prolines
realises82420183realises
realities9316313realities
realizes173116843realizes
realties8514853realties
recites93524583re_cites
reclines103718543reclines
redlines93916083redlines
reflates113115663reflates
reflies104418533refli_es
regoliths1344113regoliths
relates73731433re_lates
relies65036423re_li_es
relines75331323re_lines
relives104619443re_lives
replates102919273replates
repletes102812473repletes
replies94521043repli_es
requites171511763requites
resites74027793re_sites
reslates83619503reslates
resolutes968193resolutes
respites10513243respites
reunites8312473reunites
rewrites11311063rewrites
rhyolites1545033rhyolites
scolices1238733scolices
sepiolites1246013sepiolites
setlines8312743setlines
solates73523853_solates
solutes73515263_solutes
somites94219123_somites
sopites93817173_sopites
sorites73825243_sorites
spoliates1138543spoliates
stellites938123stellites
stylites11168693stylites
tectites1039993tectites
tektites1236613tektites
tellies73820503telli_es
tenorites9311103tenorites
teosintes944553teosintes
tergites9310543tergites
termites10313693termites
thorites11312393thorites
tillites8312833tillites
tremolites1256053tremolites
troilites948433troilites
uralites82112723uralites
uroliths1154923uroliths
veloutes1136153veloutes
verites103822263ve_rites
violates11311193violates
voltes94915583_vol_tes
volutes102710983_volutes
websites1335183websites
wellies103719073welli_es
wellsites1244673wellsites
woolies104117363wooli_es
xenoliths1943313xenoliths
zealots1636763zealot_s
zebrines1935883zebrines
zeniths1935153ze_niths
zincites1946633zincites
zloties1639913zloti_es
zoisites1744973zoisites
zoolater1746093zoolater
zoolaters1844983zoolaters

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.406440125.6
2DLD Change Limit1461622027.04620744.0
3Display Results2022020.0762657.9
 (SQL Overall)1786912027.52823736.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.