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

122 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
crustless115540(None) 
crestless1146781crestless
rustless83510241_rustless
trustless955951trustless
brushless1444002brushless
causeless1135192causeless
costless10310002c_ostless
countless1146372countless
crustiest112410052crustiest
crustiness1237292crustiness
dustless9328352_dustless
frostless1235742frostless
fruitless1244162fruitless
gustless9287682_gustless
restless82713162_restless
rustlers8339852_rustlers
rustles73416412_rustle_s
artless73712513ar__tless
bractless1335543bractless
bristles101510433bristle_s
bushless1335813_bushless
bustlers104210613_bustlers
bustles93816323_bustle_s
cashless1336773c_ashless
castles94917733c_astle_s
ceaseless1135733ceaseless
chartless1435703chartless
classless1143843classless
clueless1035883clu_eless
clusters102912403clust_ers
coatless1039693c_oatless
countess103710053count_ess
crassness1136213crassness
creaseless1243643creaseless
crewless1335413cr_ewless
crimeless1335063crimeless
crispness1345303crispness
cropless1237793cr_opless
crosslets1145183crosslets
crossness1137093crossness
crownless1443423crownless
crudeness1245753crudeness
cruelest1059183cru_elest
cruellest1155583cruellest
cruelness1145053cruelness
crullers1047303cru_llers
crumbles14329683crumble_s
crumples14348813crumple_s
crusaders1243453crusaders
crusades1146333crusade_s
cruses88127713crus__e_s
crusets93811043crus__ets
crushers134010093crus_hers
crushes124215133crus_he_s
crusted103712753crust_e_d
crustier10259533crustie_r
crustose1045503crust_ose
crusts84916543crust___s
cuffless1634293c_uffless
cureless10319703c_ureless
curtness1037263c_urtness
cutlass938013c_u_tlass
cutlers94217003c_u_tlers
cutlets94113653c_u_tlets
cuttles93613923c_uttle_s
dauntless1033663dauntless
doubtless1243313doubtless
ductless11196313_ductless
faultless1243163faultless
feastless1235043feastless
fretless1138063fr_etless
frontless1235403frontless
fruitlets1243173fruitlets
frustules1244663frustule_s
fuseless11237233_fuseless
grassless1034303grassless
gristles9189203gristle_s
gruntles9287233gruntle_s
gutless82610713_gu_tless
houseless1237463houseless
hurtless11307783_hurtless
hustlers11349203_hustlers
hustles103414173_hustle_s
justles143311433_justle_s
justness1535323_justness
listless8269263_listless
mastless102610023_mastless
pastless102411203_pastless
prestress1138133prestress
printless1137513printless
restress82511773_restress
riftless1136943_riftless
riskless1235763_riskless
rootless83910443_rootless
ruleless836633_ruleless
rumpless12256543_rumpless
rungless956733_rungless
runless72810423_ru_nless
rustiest83116803_rustiest
rustiness92111933_rustiness
rustle63615413_rustle__
rustled83311323_rustle_d
rustler73512343_rustle_r
ruthless1135413_ruthless
trestles83012553trestle_s
truceless11235393truceless
trustees8339323trust_ees
trusters83112263trust_ers
trusties82712853trustie_s
trustiest9239083trustiest
trustiness1036653trustiness
truthless1244033truthless
tuskless1234213_tuskless
useless7188423__useless
vestless11258843_vestless
waistless1235093waistless
wrastles11328933wrastle_s
wrestlers12306103wrestlers
wrestles113310063wrestle_s
wristlets1244473wristlets
yeastless1234053yeastless
zestless17247433_zestless

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.420425454.8
2DLD Change Limit1486411227.80019056.5
3Display Results1221220.0462652.2
 (SQL Overall)1786911228.26621617.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.