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

158 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
exilic159778(None) 
enolic8413352enolic
exile126117652exil_e
exiled144712462exiled
exiler134712182exiler
exiles134816402exiles
exilian1446962exilian
exiling15311082exiling
exonic153211412exonic
exotic153112652exotic
hexylic2243032hexylic
oxalic1537092oxalic
oxidic1635942oxidic
abulic106411423abulic
acidic113612133acidic
acinic104713543acinic
adipic1137263adipic
amidic114012873amidic
aminic104413513aminic
amylic13108713amylic
anilin6417793anilin
anisic8313793anisic
atelic8313703atelic
aulic74420243_aulic
auxinic1644713auxinic
axenic154210003axenic
axil116424453axil__
axile126020513axil_e
axilla13289573axilla
axils127217503axil_s
axonic154312723axonic
bailie83818363bailie
basilic1137493basilic
beylic1337823beylic
ceili75814793ceili_
ceilis85413743ceilis
chili106218483chili_
chilis115517873chilis
cilia73016763_cilia
cilice103213353_cilice
civic123412543_civic
clinic104312793clinic
clitic103315053clitic
colic95726173_colic
crisic103611843crisic
critic103616813critic
cyclic1238033cyclic
deific1237313deific
ecbolic1345623ecbolic
ecesic10369223ecesic
echoic1339043echoic
edenic9310223edenic
edifice1344933edifice
edile64819493edil_e
ediles74016983ediles
eidolic1047063eidolic
ekistic1377843ekistic
elicit8417203elicit
elixir1333703elixir
embolic1347423embolic
emetic10614453emetic
emic86422753e__mic
empiric1345963empiric
enatic8317563enatic
eosinic947713eosinic
epeiric1145313epeiric
epibolic1444913epibolic
epic86921303e__pic
epigeic1245983epigeic
epilog976463epilog
epizoic2045193epizoic
eristic9814093eristic
erotic82620273erotic
ethic101511223e_thic
ethnic1148853ethnic
ethylic1546323ethylic
etic66123953e__tic
evil75318073evil__
eviler94811893eviler
evilly1236593evilly
evils84114263evil_s
exalt123018533exal_t
exalts13328313exalts
exclaim1844943exclaim
exec135313943ex__ec
exhibit1945253exhibit
exilers14419733exilers
exine125518493exi_ne
exines135715803exines
exing136016813exi_ng
exist124618943exi_st
exists134710913exists
exit114428673ex__it
exited144712523exited
exiting15311393exiting
exits125515913exi_ts
exosmic1844373exosmic
exotica16257603exotica
exotics16229193exotics
explain1667043explain
explicit1946463explicit
exploit1648623exploit
exult122814123exul_t
exults13257633exults
exuvia1644223exuvia
eyelid1038443eyelid
filmic13348453_filmic
flic96223733__flic
folic105319323_folic
frolic1149203frolic
gallic9411643gallic
garlic9310043garlic
hexadic2045413hexadic
hili75626633_hili_
ilia46026823__ilia
iliac75013493__iliac
imidic11358203imidic
iridic9328743iridic
iritic83213823iritic
italic839903italic
kilim11711893_kilim
lexemic1844283lexemic
lilac7311073_lilac
malic94525663_malic
melic94722333_melic
milia72719573_milia
mimic111414323_mimic
neritic91314333neritic
otitic83112683otitic
oxalis1339223oxalis
oxlip1456883ox_lip
pelitic111814653pelitic
phylic16279553phylic
pili66130353_pili_
pilis75825203_pilis
preexilic2042533preexilic
public12238143public
quinic17319473quinic
relic74623363_relic
resilin72913973resilin
salic73424713_salic
sedilia847243sedilia
sexily1638853sexil_y
sialic8313633sialic
silica8311243_silica
stelic8313083stelic
taxitic1637093taxitic
telic76019823_telic
thiolic1247323thiolic
twilit949553twilit
unific1137463unific
veridic1338143veridic
vexil1538963vexil__
vexilla1744663vexilla
vexils1647173vexil_s
vinic10314973_vinic
xenic144114643_xenic
xeric144315663_xeric

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.376475242.0
2DLD Change Limit1127161585.29621283.2
3Display Results1581580.0463434.8
 (SQL Overall)1786911585.71831250.6
 
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.