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

112 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
elixir133370(None) 
elixirs1443541elixirs
elicit8417202elicit
alexia132910463alexia
alexin132311483alexin
alibi7514233alibi_
alibis8311073alibis
aliner65621983aliner
belier84423563beli_er
blini75519273blini_
blinis85313683blinis
clinic104312793clinic
clitic103315053clitic
clivia1177233clivia
deixis1437243deixis
delimit10311733delimit
deliria868303deliria
deliver113312243deliver
dixit134420593_dixit
eclair836813eclair
edifier11309263edifier
editor738663editor
eelier64216463eeli_er
eider64624743e_ider
elain55324703el_ain
elapid939543elapid
elater64724203elater
elder64020023el_der
elegit71212893elegit
elemi7312503elemi_
elemis8312383elemis
elfin84312463el_fin
elhi7612403el_hi_
elicitor1045773elicitor
elicits9311233elicits
elide64922643eli_de
elided84814673elided
elides74420693elides
eliding93414343eliding
elint55436473eli_nt
elints65816423elints
elision72311103elision
elite56230183eli_te
elites66027123elites
elitism939763elitism
elitist7414913elitist
elmier839813elmier
eloin55923203el_oin
eloiner7149183eloiner
eloper85414153eloper
eluder73712213eluder
eluvia936133eluvia
elver85216243el_ver
emir65918703e__mir
epimer10109153epimer
eviler94811893eviler
exiler134712183exiler
exilic1597783exilic
exit114428673e__xit
eyrir8359653e_yrir
fixer154717833_fixer
fixit154819303_fixit
flair86114123fl_air
flaxier17337983flaxier
flexor1634503flexor
flier86023403fli_er
flir76422203fl__ir
glair65313553gl_air
glider84614263glider
helix154413013helix__
helixes1739133helixes
ixia115713213__ixia
lair45934153_l_air
laxer125420333_laxer
lexis125916033_lexis
liar47229683_li_ar
liber74723623_liber
libri74610113_libri
licit74327683_licit
lidar6312723_lidar
lier45942463_li_er
lifer85822153_lifer
liger65024473_liger
liker95627063_liker
limier83518723_limier
limit73126343_limit
liner55938923_liner
linier64423793_linier
linin58025523_linin
lipid85916173_lipid
lipin75518893_lipin
liri45128253_liri_
liter54736343_liter
liver85132963_liver
livid96714423_livid
livier97514593_livier
mixer145017643_mixer
nixie125114943_nixie
pelitic111814653pelitic
pixie145415523_pixie
plexor1535253plexor
plier75221283pli_er
relaxer143410223relaxer
relaxin14239183relaxin
relier65826183reli_er
slicer84117603slicer
slider73918363slider
slier54827243sli_er
slimier93212013slimier
sliver94116593sliver
veliger1137313veliger
vizir17359393_vizir

Search took 6 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 Filter1786911127160.203880251.2
2DLD Change Limit1127161125.50020493.8
3Display Results1121120.0462434.8
 (SQL Overall)1786911125.74931082.1
 
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.