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

109 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
shiftless1526530(None) 
shirtless12266411shirtless
shitless11249241shi_tless
giftless1245172_giftless
hiltless11297122_hiltless
hitless103211192_hi_tless
riftless1136942_riftless
sheetless1235822sheetless
shifters14319862shift_ers
shiftiest1537362shiftiest
shiftiness1644792shiftiness
shiftlessly2052432shiftlessly
shipless13277692shi_pless
skiffless19243052skiffless
skirtless13254422skirtless
slitless8268142sli_tless
swiftlets1542722swiftlets
swiftness1543652swiftness
thriftless1642212thriftless
chartless1435703chartless
childless1543813childless
chinless1337493chi_nless
exitless1534883exi_tless
guiltless1043023guiltless
haltless11308443_haltless
hatless103813443_h_atless
heatless113011463_heatless
hideless12278713_hideless
hipless12399923_hi_pless
hiveless14227933_hiveless
hurtless11307783_hurtless
jointless1634323jointless
lifeless11228143_lifeless
lintless82710013_lintless
listless8269263_listless
loftless1135903_loftless
pointless1135703pointless
printless1137513printless
sailless82410373sai_lless
saltless8259343s_altless
scentless1135113scentless
seatless83213003s_eatless
selfless1135013self_less
shadeless1335733shadeless
shameless1435923shameless
shapeless1435563shapeless
shifted14359983shift_e_d
shifter132911083shift_e_r
shiftier1436343shiftie_r
shifts124412943shift___s
shinglers13246443shinglers
shingles123111113shingle_s
shininess1237333shininess
shirtdress1441813shirtdress
shirtiest1239323shirtiest
shitlist1148723shi_tlist
shitlists1245533shi_tlists
shittiest1238333shittiest
shoeless1137803sh_oeless
shoreless1236633shoreless
shortness1236733shortness
shufflers18265153shufflers
shuffles17297783shuffle_s
shuttlers1254123shuttlers
shuttles1136553shuttle_s
sifters103714793s_ift_ers
sighless1276553s_ighless
sightless1385923sightless
sinless73014213s_i_nless
skiffles18265713skiffle_s
skilless12246763ski_lless
skinless12216973ski_nless
skittles1245763skittle_s
slipless10246993sli_pless
smileless1134693smileless
snifflers15275053snifflers
sniffles14257723sniffle_s
snifters11318613snift_ers
softness1136433s_oftness
soilless8279033soi_lless
spiceless1335923spiceless
spineless1136133spineless
spinless10238703spi_nless
spiritless1243743spiritless
spittles1038333spittle_s
spotless1037043s_potless
spoutless1134243spoutless
stiffness1543553stiffness
stiflers11238833stif_lers
stifles103013393stif_le_s
stingless1046463stingless
strifeless1343213strifeless
stuffless1543543stuffless
swifters14277483swift_ers
swiftest1434353swift_est
swiftlet1444793swiftle_t
taintless935733taintless
thistles1198233thistle_s
tintless8239863_tintless
waistless1235093waistless
wheatless1534003wheatless
whifflers2142773whifflers
whiffles2034263whiffle_s
whistlers1595163whistlers
whistles14108213whistle_s
whittlers1594333whittlers
whittles1496673whittle_s
wifeless14277483_wifeless
witless103310983_wi_tless

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.423422437.4
2DLD Change Limit1486411096.48322927.8
3Display Results1091090.0462369.6
 (SQL Overall)1786911096.95225703.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.