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

123 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
graceless1222689(None) 
gradeless11236701gradeless
grateless10277581grateless
graveless13226691graveless
traceless11228641traceless
bracelets1345962bracelets
bractless1335542bractless
brakeless1544992brakeless
faceless13269172_faceless
frameless1435532frameless
gateless9279952g_ateless
gracelessly1752632gracelessly
graciles112511612gracile_s
grackles15309182grackle_s
grainless1035892grainless
grassless1034302grassless
graveness13288382graveness
greaseless1143482greaseless
groveless13235362groveless
laceless10239852_laceless
placeless1335612placeless
priceless1336882priceless
spaceless1335732spaceless
trackless15246722trackless
truceless11235392truceless
ageless8310343__ageless
aweless1038723__aweless
backless162910633_backless
baseless1099563_baseless
bladeless1234303bladeless
blameless1334733blameless
bracelet12310693bracele_t
bractlets1344753bractlets
brainless1136403brainless
braless92910563bra__less
branchless1743303branchless
brandless1236123brandless
braveness14237763braveness
brineless1136243brineless
careless102813633_careless
ceaseless1135733ceaseless
crackles164111273crackle_s
creaseless1243643creaseless
crimeless1335063crimeless
dateless9259963_dateless
fadeless12258323_fadeless
fameless13259203_fameless
fenceless1444163fenceless
flameless1435353flameless
forceless1435723forceless
frockless1843453frockless
gainless9117403g_ainless
gameness112810693g_ameness
gapless10349993g_a_pless
garbless11388253g_arbless
gasless8319013g_a_sless
gearless937373gea_rless
glandless1134163glandless
glassless1043873glassless
glebeless1242953glebeless
goalless935723goa_lless
grabblers14345513grabblers
grabbles13339893grabble_s
gracefulness1855243gracefulness
graces94523493grac__e_s
gracile102512603gracile__
gracileness1444143gracileness
gracilis11247033gracil_is
grackle14338893grackle__
grandness1138303grandness
granules939933granule_s
grapiness1238253grapiness
grapplers14274303grapplers
grapples13348123grapple_s
graveled13417363gravele_d
gravels113611143gravel__s
grayness1235933gra_yness
greedless1144893greedless
grovelers13305163grovelers
gruelers936173gr_uelers
guideless1143843guideless
guileless1044253guileless
iceless9219963__iceless
irateness9310493irateness
ireless72312243ir__eless
juiceless1843253juiceless
maneless102812343_maneless
mateless102711293_mateless
nameless10248373_nameless
oracles93212423orac_le_s
paneless102611763_paneless
racemes1139093_raceme_s
raciness102413453_raciness
rainless8129703_rainless
ranchless1444453_ranchless
rankless12268233_rankless
rareness81112853_rareness
ravelers113310863_ravelers
rayless10239003_ra_yless
reckless14257973_reckless
rockless14297293_rockless
ruleless836633_ruleless
scaleless1135513scaleless
shadeless1335733shadeless
shameless1435923shameless
shapeless1435563shapeless
spiceless1335923spiceless
stackless1555933stackless
stateless937563stateless
tackless14419483_tackless
tactless10288463_tactless
tameless10259903_tameless
tapeless10218643_tapeless
trachles13311753trachle_s
trailless935963trailless
tramless1037503tra_mless
travelers12266773travelers
treeless839283tr_eeless
viceless1337983_viceless
voiceless1444223voiceless
wageless1237173_wageless
wakeless1536473_wakeless
waveless1437483_waveless

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 Filter1786911486410.440406115.9
2DLD Change Limit1486411236.78021923.5
3Display Results1231230.0631952.4
 (SQL Overall)1786911237.28324535.4
 
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.