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

103 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
scentless113511(None) 
accentless1442562accentless
eventless1244602eventless
scantness1135732scantness
seatless83213002s_eatless
sheetless1235822sheetless
tentless8229842_tentless
ventless11249052_ventless
assetless943573asse_tless
beatless103311593_beatless
beltless10297713_beltless
cantles94721413_cantle_s
centerless1245003_centerless
centers94420603_cent_ers
centeses1079443_cent_eses
centesis1058143_cent_esis
centiles103615813_centile_s
centners1057243_centners
centres93817123_centre_s
clientless1272493clientless
coatless1039693_coatless
costless10310003_costless
countless1146373countless
crestless1146783crestless
dauntless1033663dauntless
debtless1135653_debtless
endless839833__endless
feetless1137383_feetless
fretless1138063fre_tless
frontless1235403frontless
gentles83714343_gentle_s
gentlest93410573_gentlest
heatless113011463_heatless
iceless9219963ice__less
jointless1634323jointless
lensless835583_lensless
lintless82710013_lintless
meatless103410863_meatless
netless739863_ne_tless
parentless1244453parentless
peltless10267373_peltless
pleatless1134613pleatless
poetless1038723poe_tless
pointless1135703pointless
printless1137513printless
recentness1245463recentness
relentless1043703relentless
restless82713163_restless
saltless8259343s_altless
sandless93212343s_andless
scaleless1135513scaleless
scantest101710183scant_est
scanties103215423scantie_s
scantiest112611013scantiest
scantiness1236883scantiness
scarless10189053sc_arless
scenes84520353scen__e_s
scented102811883scent_e_d
scents85317023scent___s
scepters1237793scept_ers
sceptres1244993sceptre_s
scoreless1155603scoreless
scumless1254993sc_umless
scuttles1056503scuttle_s
seamless10238723s_eamless
seedless9319513s_eedless
selfless1135013s_elfless
seniles72618023s_enile_s
senseless945973s_enseless
settlers8289023s_ettlers
settles73916003s_ettle_s
sexless1467243s_e_xless
shiftless15265303shiftless
shirtless12266413shirtless
shitless11249243s_hitless
sightless1385923sightless
silentness1044573silentness
sinewless1244363sinewless
sinless73014213s_in_less
skinless12216973skin_less
skirtless13254423skirtless
sleepless1144553sleepless
slitless8268143s_litless
solventless1451273solventless
songless9218823s_ongless
sonless72612613s_on_less
soundless1035533soundless
spanless10247363span_less
spineless1136133spineless
spinless10238703spin_less
spotless1037043s_potless
spoutless1134243spoutless
stemless1036653ste_mless
stingless1046463stingless
sunless73013693s_un_less
sweetness1245683sweetness
taintless935733taintless
talentless1042803talentless
textless15245793_textless
tintless8239863_tintless
vestless11258843_vestless
wheatless1534003wheatless
zestless17247433_zestless

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 Filter1786911486410.420425454.8
2DLD Change Limit1486411036.31323545.2
3Display Results1031030.0462239.1
 (SQL Overall)1786911036.77926359.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.