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

134 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
crestless114678(None) 
crustless1155401crustless
restless82713161_restless
costless10310002c_ostless
creaseless1243642creaseless
crewless1335412cre_wless
fretless1138062fre_tless
frostless1235742frostless
prestress1138132prestress
restress82511772_restress
rustless83510242_rustless
trestles83012552trestle_s
trustless955952trustless
vestless11258842_vestless
wrestlers12306102wrestlers
wrestles113310062wrestle_s
zestless17247432_zestless
accentless1442573accentless
artless73712513ar__tless
assetless943573assetless
beatless103311593_beatless
beltless10297713_beltless
bractless1335543bractless
breadless1235943breadless
breathless1543533breathless
bristles101510433bristle_s
brushless1444003brushless
caestuses1144893caestuses
careless102813633care__less
cashless1336773c_ashless
castles94917733c_astle_s
causeless1135193causeless
ceaseless1135733ceaseless
cestuses1038083c_estuses
chartless1435703chartless
checkless2044233checkless
cheekless1873883cheekless
cheerless1495293cheerless
chestiest1438313chestiest
classless1143843classless
clientless1272493clientless
coatless1039693c_oatless
coreless103013833core__less
countless1146373countless
crassness1136213crassness
creates95225203creat_e_s
creoles9913323cre_ole_s
cresols939653cresol__s
cresses94219813cres_se_s
cressets10309103cres_sets
crested103416553crest_e_d
crestings12298043crestings
crests85218703crest___s
cresyls1234753cresyl__s
crimeless1335063crimeless
crispness1345313crispness
cropless1237793cr_opless
crosslets1145183crosslets
crossness1137093crossness
crownless1443423crownless
crustiest112410053crustiest
crustiness1237303crustiness
cureless10319703cure__less
debtless1135653_debtless
dreamless1243513dreamless
dustless9328353_dustless
erectness1146123erectness
eventless1244603eventless
feastless1235043feastless
feetless1137383_feetless
fleshless1543993fleshless
freshness1545943freshness
frontless1235403frontless
fruitless1244163fruitless
grassless1034303grassless
greaseless1143483greaseless
greatness1036903greatness
greedless1144893greedless
gristles9189203gristle_s
gustless9287683_gustless
heatless113011463_heatless
ireless72312243ire__less
listless8269263_listless
mastless102610023_mastless
meatless103410863_meatless
meritless1144593meritless
nestlers8359233_nestlers
nestles73015463_nestle_s
netless739863_ne_tless
parentless1244463parentless
pastless102411203_pastless
peltless10267373_peltless
pestles93217693_pestle_s
pleatless1134613pleatless
poetless1038723poe_tless
prebless1236823pre_bless
presales10315263presale_s
presters103419003prest_ers
priestess1145293priest_ess
printless1137523printless
reckless14257973_reckless
reinless8139443_reinless
resales74724903_resale_s
resiles74026543_resile_s
resistless1043173_resistless
resoles73823653_resole_s
resters74130403_rest_ers
restlessly1344263_restlessly
restyles1139193_restyle_s
resultless1041953_resultless
riftless1136943_riftless
riskless1235763_riskless
rootless83910443_rootless
rustlers8339853_rustlers
rustles73416413_rustle_s
scentless1135113scentless
seatless83213003_seatless
sheetless1235823sheetless
stressless942763stressless
tentless8229843_tentless
textless15245793_textless
treadless1036003treadless
treeless839283tre_eless
trestle72611363trestle__
ventless11249053_ventless
waistless1235093waistless
wheatless1534003wheatless
wrastles11328933wrastle_s
wresters112711733wrest_ers
wrestle10298843wrestle__
wrestled12296763wrestle_d
wrestler11306993wrestle_r
wristlets1244473wristlets
yeastless1234053yeastless

Search took 9 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.453394461.4
2DLD Change Limit1486411347.48619855.9
3Display Results1341340.0602233.3
 (SQL Overall)1786911347.99922339.2
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.