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

172 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
elitist741491(None) 
elitism939761elitism
elitists848541elitists
egotist8411272egotist
elegist81311972elegist
elicit8417202elici_t
elicits9311232elicits
elites66027122elites_
elitisms1048192elitisms
etatist7415032etatist
flutist102910782flutist
leftist10279352leftist
lutist64317552_lutist
semitist10413322semitist
alibis8311073alibis_
alienist8411993alienist
alist56136783al__ist
alpinist1059153alpinist
altoist7313393altoist
animist93815173animist
artist64125543_artist
autist64324943_autist
baptist11311873baptist
blinis85313683blinis_
blites84721213blites_
blithest1338083blithest
cellist9314423cel_list
chutist1239453chutist
cladist10311973cladist
clitic103315053cliti_c
clitics11279973clitics
colitis92617353colitis_
cultist91412713cultist
declinist1247653declinist
delimit10311733delimi_t
delimits1137573delimits
delist74625053del__ist
demotist11311843demotist
dentist8316743dentist
editing9313133editing
edition8310853edition
edits65819033edit_s_
eeliest73516473eeli_est
egoist7612283e_goist
egotism1038353egotism
egotists937063egotists
elates65032363elates_
elating83423083elating
elation73620453elation
elative10312453elative
eldest72912683el_dest
elegise8139393elegise
elegists9128113elegists
elegit71212893elegi_t
elegits8149343elegits
elemis8312383elemis_
elfish1267963el_fish
elides74420693elides_
eliding93414343eliding
elint55436473el__int
elints65816423elints_
elision72311103elision
elite56230183elit__e
elixir1333703elixi_r
elixirs1443543elixirs
elmiest9310743elmiest
elutes64020313elutes_
eluting84115293eluting
elution72913823elution
elvish1277563el_vish
emits75421473emit_s_
emptiest1278103emptiest
enlist6417043e_nlist
entwist1048803entwist
eoliths10318573eoliths_
epeeist938863epeeist
epithet12312463epithet
erotism9312303erotism
etatism9610293etatism
ethicist1347893ethicist
eulogist949043eulogist
evilest10310473evilest
evites94916473evites_
eviting11511373eviting
exist124618943e__xist
exiting15311393exiting
exits125515913exit_s_
exotism1638123exotism
feminist131911333feminist
flautist1186803flautist
fliest94718433fli_est
flintiest1248433flintiest
flirtiest1236193flirtiest
flites95122443flites_
fliting113514613fliting
flits85625223flit_s_
florist10314243florist
flutiest112610883flutiest
flutists11256413flutists
gelatis83313513gelatis_
glintiest1037623glintiest
glitziest1944003glitziest
heliast10312073heli_ast
helilift1445183helilift
helotism1347703helotism
ileitis738063ileitis_
iritis63113733iritis_
latest63822703_latest
latish92416173_latish
leftest10269463leftest
leftish13197253leftish
leftism12226093leftism
leftists11235513leftists
legist71315253_legist
lentisk1136063lentisk
liaise6310693_liaise
licit74327683_lici_t
likest104914383_likest
limiest93716103_limiest
limit73126343_limi_t
limits82514143_limits
liniest73321153_liniest
lintiest82715913_lintiest
list47055343_l__ist
litas54923773_litas_
lithest10513913_lithest
lits46252493_lit_s_
livest95315733_livest
lutists73810273_lutists
lyrist9312293_lyrist
melanist10313053melanist
meliorist1148463meliorist
melodist1149743melodist
miltiest103015173miltiest
mitiest93520053_mitiest
mitis75425993_mitis_
myelitis1345113myelitis_
nepotist1059233nepotist
ologist8313833ologist
otitis63612343otitis_
pelites93821993pelites_
pelitic111814653peliti_c
peltast9310513pel_tast
pietist9414033pietist
platiest103216083platiest
plenist9314333plenist
politest10312943politest
protist9320223protist
pyelitis1346583pyelitis_
quietist1767493quietist
relist64628413rel__ist
semitists1148183semitists
shitlist1148723shitlist
siltiest83515613siltiest
slatiest82616263slatiest
sliest66621953sli_est
slimiest10310743slimiest
slits56128853slit_s_
slittiest938203slittiest
statist7317723statist
thelitis1147513thelitis_
titis56023813_titis_
titlist7312923_titlist
tritest7315273tritest
vegetist1257393vegetist
velites103417303velites_
vibist11610583_vibist
waitlist1147743waitlist
whitest133710113whitest
whitiest14259883whitiest
whitish1635973whitish
zitis145815583_zitis_

Search took 7 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 Filter1786911340270.406440125.6
2DLD Change Limit1340271726.32621186.7
3Display Results1721720.0632730.2
 (SQL Overall)1786911726.79526297.4
 
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.