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

203 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
giftless124517(None) 
riftless1136941riftless
giftees11306512gift_ees
guiltless1043022guiltless
gustless9287682gustless
gutless82610712g_utless
hiltless11297122hiltless
hitless103211192hi_tless
lifeless11228142lifeless
lintless82710012lintless
listless8269262listless
loftless1135902loftless
shiftless15265302shiftless
tintless8239862tintless
wifeless14277482wifeless
witless103310982wi_tless
aidless83612073ai_dless
aimless93610813ai_mless
airless73712043ai_rless
artless73712513_artless
beatless103311593beatless
beltless10297713beltless
bibless11439173bi_bless
blotless10347153blotless
boltless10338283boltless
bootless103410983bootless
coatless1039693coatless
costless10310003costless
cuffless1634293cuffless
daftness1235533daftness
debtless1135653debtless
deftness1236303deftness
distress9311713distress
ductless11196313ductless
dustless9328353dustless
exitless1534883exitless
fatless103212203_fatless
feetless1137383feetless
fifteens1442753fifteens
fifties132111083fiftie_s
filmless1344553filmless
finless102810783fi_nless
fireless112810593fireless
fishless1436413fishless
fitness10299393fi_tness
footless113710803footless
fretless1138063fretless
gainless9117413gainless
gantlets9308903gantlets
gapless10349993g_apless
garbless11388253garbless
gasless8319013g_asless
gastness9278483gastness
gateless9279953gateless
gearless937373gearless
gentles83714343gentle_s
gentlest93410573gentlest
giantess933893giantess
giblets103210423gi_blets
giftables1572593giftable_s
gifted114510703gift_e_d
giftedness1543683giftedness
giftee103512083gift_e_e
gifts96214963gift___s
gigglers11297403gigglers
giggles103312933giggle_s
giglets93211553gi_glets
gillers84216903gi_llers
gimlets10338433gi_mlets
girdlers10195403girdlers
girdles92210003girdle_s
gites65630183gi_t_e_s
goalless935723goalless
godless938403g_odless
gormless11235443gormless
grateless10277583grateless
grifters12389233grift_ers
gristles9189203gristle_s
guideless1143843guideless
guileless1044253guileless
gumless10228273g_umless
gunless8299633g_unless
guttlers9306933guttlers
guttles83011933guttle_s
haltless11308443haltless
hatless103813443_hatless
heatless113011463heatless
hideless12278713hideless
hipless12399923hi_pless
hiveless14227933hiveless
hurtless11307783hurtless
iceless9219963_iceless
inkless11348713_inkless
innless7288293_innless
ireless72312243_ireless
istles62814983_istle_s
ixtles13217063_ixtle_s
jointless1634323jointless
kindless13289243kindless
kingless13288693kingless
kinless113310273ki_nless
kirtles11309663kirtle_s
kittles113012493kittle_s
kittlest12297573kittlest
knotless1264573knotless
lidless8309273li_dless
lifters104313783lift_ers
lightless1386073lightless
limbless12246313limbless
limeless10249663limeless
limitless1142943limitless
lineless82711943lineless
lipless9259553li_pless
littles73212783little_s
littlest8309243littlest
mastless102610023mastless
matless93014043_matless
meatless103410863meatless
milkless1434773milkless
mindless11319443mindless
mirthless1443353mirthless
mistress10310703mistress
netless739863_netless
nifties102612503niftie_s
niftiest112910073niftiest
niftiness1236363niftiness
nightless1386073nightless
pastless102411203pastless
peltless10267373peltless
piffles15368773piffle_s
pileless1088623pileless
pilotless1143993pilotless
pintles94118733pintle_s
pipeless12107663pipeless
pithless13117023pithless
pitiless10127333pitiless
plotless10256793plotless
poetless1038723poetless
pointless1135713pointless
portless10310643portless
printless1137523printless
restless82713163restless
ribless93410343ri_bless
rifeness1138603rifeness
rifflers14336453rifflers
riffles133911173riffle_s
riflers103512203rif_lers
rifles94217713rif_le_s
rimless9369363ri_mless
rindless92510203rindless
riskless1235763riskless
rootless83910443rootless
rustless83510243rustless
saltless8259343saltless
seatless83213003seatless
shirtless12266413shirtless
shitless11249243shitless
sifters103714793sift_ers
sighless1276553sighless
sightless1385923sightless
sinless73014213si_nless
skiffless19243053skiffless
skirtless13254423skirtless
slitless8268143slitless
softness1136433softness
spotless1037043spotless
swiftlets1542723swiftlets
swiftness1543653swiftness
tactless10288463tactless
taintless935743taintless
tentless8229843tentless
textless15245793textless
thriftless1642213thriftless
tideless9269083tideless
tieless72512563ti_eless
timeless10239543timeless
tipless92610063ti_pless
tireless82510263tireless
titles63719923ti_tle_s
tittles73413253tittle_s
ventless11249053ventless
vestless11258843vestless
viceless1337983viceless
victress1344523victress
viewless1434033viewless
vistaless1254573vistaless
vittles103211113vittle_s
waistless1235093waistless
wartless11279923wartless
wattless11268723wattless
wickless1736083wickless
wiftiest14279173wiftiest
wigless11359673wi_gless
windless123310863windless
wineless112711173wineless
wingless122910023wingless
winless103212283wi_nless
wintles103414983wintle_s
wireless11249633wireless
wishless1435993wishless
witness103010013wi_tness
zestless17247433zestless
zipless18276303zi_pless

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 Filter1786911461620.406440125.6
2DLD Change Limit1461622036.95321021.4
3Display Results2032030.0762671.1
 (SQL Overall)1786912037.43524033.8
 
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.