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

162 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
knotless126457(None) 
blotless10347152blotless
bootless103410982bootless
footless113710802footless
knockless1442442knockless
knollers12255142knollers
knotters12276152knotters
netless739862_netless
noteless839402_noteless
plotless10256792plotless
rootless83910442rootless
snowless1145632snowless
spotless1037042spotless
anoles64827433ano_le_s
antlers74014743an_tlers
artless73712513_artless
beatless103311593beatless
beltless10297713beltless
boltless10338283boltless
bondless1148813bondless
boneless10310213boneless
boonless10328353boonless
bootlegs11325873bootlegs
bowless123310313_bowless
browless1346653browless
coatless1039693coatless
cookless14258633cookless
costless10310003costless
coxless1637743_coxless
cropless1237793cropless
debtless1135653debtless
doorless936713doorless
ductless11196313ductless
dustless9328353dustless
egoless836983ego_less
endless839833en_dless
exitless1534883exitless
fatless103212203_fatless
feetless1137383feetless
fogless1138193_fogless
foodless12338383foodless
footlers113910793footlers
footles103715713footle_s
fretless1138063fretless
frontless1235403frontless
frostless1235743frostless
giftless1245173giftless
godless938403_godless
gustless9287683gustless
gutless82610713_gutless
haltless11308443haltless
hatless103813443_hatless
heatless113011463heatless
hiltless11297123hiltless
hitless103211193_hitless
hoodless12289733hoodless
hoofless14258013hoofless
hookless151238363hookless
hoopless13279263hoopless
hotness1038613_hotness
hurtless11307783hurtless
inkless11348713in_kless
innless7288293in_nless
jobless16237563_jobless
joyless17226513_joyless
keelless12236193keelless
kettles113411613kettle_s
keyless1436163k_eyless
kindless13289243kindless
kingless13288693kingless
kinless113310273k_inless
kirtles11309663kirtle_s
kittles113012493kittle_s
kittlest12297573kittlest
kneelers12226213kneelers
knitters12336623knitters
knockers13285733knockers
knolled12296573knolle_d
knoller11285913knolle_r
knolls10367413kno_l_ls
knotgrass1451683knotgrass
knotholes1644173knothole_s
knotlike1144003knotlike
knots95614723knot___s
knotted12357233knotte_d
knotter11317643knotte_r
knottiest13174563knottiest
knottiness1483593knottiness
knotweed1642103knotweed
knotweeds1741663knotweeds
knowers1436353kno_wers
lintless82710013lintless
listless8269263listless
loftless1135903loftless
mastless102610023mastless
matless93014043_matless
meatless103410863meatless
moonless10278043moonless
mootness1036753mootness
motleys1235683_motleys
napless93110283_napless
nathless11127023_nathless
nobles83319723_noble_s
noblesse1044543_noblesse
noblest93613563_noblest
normless10235923_normless
noseless839513_noseless
noters64021003_not_ers
notes55034583_not_e_s
nounless837253_nounless
nowness1037033_nowness
nutlets74111253_nutlets
odorless934173odorless
pastless102411203pastless
peltless10267373peltless
pilotless1143993pilotless
poetless1038723poetless
portless10310643portless
restless82713163restless
riftless1136943riftless
rodless8310073_rodless
roofless11316733roofless
rootles73215633rootle_s
rootlets8308653rootlets
rustless83510243rustless
saltless8259343saltless
seatless83213003seatless
shitless11249243shitless
shoeless1137803shoeless
skirtless13254423skirtless
slitless8268143slitless
smogless1134053smogless
snapless10287463snapless
songless9218823songless
sonless72612613_sonless
spoutless1134243spoutless
tactless10288463tactless
tentless8229843tentless
textless15245793textless
thowless1434613thowless
tintless8239863tintless
toeless72612393_toeless
toneless8610393toneless
toolless836343toolless
toothless1244683toothless
tootlers8289503tootlers
tootles72915603tootle_s
topless92511123_topless
toyless10268713_toyless
unless62413073un__less
unstress837373unstress
ventless11249053ventless
vestless11258843vestless
voteless1137493_voteless
votress1035483_votress
vowless13246603_vowless
wartless11279923wartless
wattless11268723wattless
witless103310983_witless
woodless12278453woodless
zestless17247433zestless
zoneless1737823zoneless

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.420425454.8
2DLD Change Limit1461621627.15620425.1
3Display Results1621620.0802025.0
 (SQL Overall)1786911627.65623340.0
 
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.