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

164 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
exitless153488(None) 
editress944932editress
exilers14419732exi_lers
exiles134816402exi_le_s
hitless103211192_hitless
meritless1144592meritless
shitless11249242shitless
slitless8268142slitless
textless15245792tex_tless
witless103310982_witless
aidless83612073_aidless
aimless93610813_aimless
airless73712043_airless
artless73712513_artless
axites134913833axit_e_s
beatless103311593beatless
beltless10297713beltless
bibless11439173_bibless
blotless10347153blotless
boltless10338283boltless
bootless103410983bootless
brimless1235273brimless
chinless1337493chinless
coatless1039693coatless
costless10310003costless
debtless1135653debtless
dripless1135243dripless
ductless11196313ductless
dustless9328353dustless
earless74316073e_arless
echoless1345603echoless
edgeless1034883edgeless
edibles1048003edible_s
ediles74016983edi_le_s
eggless935663e_ggless
egoless836983e_goless
elites66027123elit_e_s
emitters10349643emitters
endless839833e_ndless
enisles72312603enisle_s
entitles8710663entitle_s
epistlers1154113epistlers
epistles1047783epistle_s
epitases1038933epitases
epithets1345763epithets
eventless1244603eventless
evilest10310473evi_lest
evillest1146353evillest
evilness1135043evilness
evites94916473evit_e_s
exactness1843623exactness
exalters1536653exalters
excess1546053ex__cess
exciples1964773exciple_s
exciters1736323excit_ers
excites16310633excit_e_s
exhales1737143exhale_s
exile126117653exi_le__
exiled144712463exi_le_d
exiler134712183exi_le_r
exines135715803exi_ne_s
exited144712523exit_e_d
exits125515913exit___s
express1637493ex_press
expulses1774813expulses
eyeless1058053e_yeless
faithless1543903faithless
fatless103212203_fatless
feastless1235043feastless
feetless1137383feetless
finless102810783_finless
fitness10299393_fitness
footless113710803footless
fretless1138063fretless
fruitless1244163fruitless
gainless9117403gainless
giftless1245173giftless
guiltless1043023guiltless
gustless9287683gustless
gutless82610713_gutless
hairless1157413hairless
haltless11308443haltless
hatless103813443_hatless
heartless1236393heartless
heatless113011463heatless
heirless1146053heirless
hiltless11297123hiltless
hipless12399923_hipless
hurtless11307783hurtless
ixtles13217063ix_tle_s
jointless1634323jointless
kinless113310273_kinless
knotless1264573knotless
lidless8309273_lidless
limitless1142943limitless
lintless82710013lintless
lipless9259553_lipless
listless8269263listless
loftless1135903loftless
mailless10248583mailless
mastless102610023mastless
matless93014043_matless
meatless103410863meatless
netless739863_netless
painless10108343painless
pastless102411203pastless
peltless10267373peltless
pithless13117023_pithless
pitiless10127333_pitiless
plotless10256793plotless
poetless1038723poetless
pointless1135703pointless
portless10310643portless
printless1137513printless
rainless8129703rainless
reinless8139433reinless
resistless1043173resistless
restless82713163restless
retitles83612593retitle_s
ribless93410343_ribless
riftless1136943riftless
rimless9369363_rimless
rootless83910443rootless
rustless83510243rustless
sailless82410373sailless
saltless8259343saltless
seatless83213003seatless
sexiness1537943sexi_ness
sexless1467243sex__less
sextiles1537643sextile_s
shiftless15265303shiftless
shipless13277693shipless
shirtless12266413shirtless
sinless73014213_sinless
skilless12246763skilless
skinless12216973skinless
skirtless13254423skirtless
slipless10246993slipless
soilless8279033soilless
spinless10238703spinless
spotless1037043spotless
tactless10288463tactless
tailless8239083tailless
taintless935733taintless
tentless8229843tentless
textiles1536833textile_s
tieless72512563_tieless
tintless8239863tintless
tipless92610063_tipless
titles63719923_title_s
twigless1293663twigless
veinless11136263veinless
ventless11249053ventless
vestless11258843vestless
waistless1235093waistless
waitress1135223waitress
wartless11279923wartless
wattless11268723wattless
wigless11359673_wigless
winless103212283_winless
witness103010013_witness
yeastless1234053yeastless
zestless17247433zestless
zipless18276303_zipless

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 Limit1461621647.42019698.4
3Display Results1641640.0802050.0
 (SQL Overall)1786911647.92322553.5
 
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.