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

257 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
riftless113694(None) 
giftless1245171giftless
hiltless11297122hiltless
hitless103211192hi_tless
lifeless11228142lifeless
lintless82710012lintless
listless8269262listless
loftless1135902loftless
printless1137512printless
restless82713162restless
ribless93410342ri_bless
rifeness1138582rifeness
rifflers14336442rifflers
riffles133911162riffle_s
riflers103512192rif_lers
rifles94217702rif_le_s
rimless9369362ri_mless
rindless92510192rindless
riskless1235762riskless
rootless83910442rootless
rustless83510242rustless
shiftless15265302shiftless
thriftless1642212thriftless
tintless8239862tintless
wifeless14277482wifeless
witless103310982wi_tless
aidless83612073ai_dless
aimless93610813ai_mless
airless73712043ai_rless
artless73712513_artless
beatless103311593beatless
beltless10297713beltless
bibless11439173bi_bless
blotless10347153blotless
boltless10338283boltless
bootless103410983bootless
bractless1335543bractless
briefless1443613briefless
brimless1235273bri_mless
brineless1136243brineless
bristles101510433bristle_s
brittles10178653brittle_s
brittlest11146193brittlest
coatless1039693coatless
costless10310003costless
crestless1146783crestless
crimeless1335063crimeless
crustless1155403crustless
cuffless1634293cuffless
daftness1235533daftness
debtless1135653debtless
deftness1236303deftness
distress9311713distress
drifters12417913drift_ers
driftiest1335943driftiest
dripless1135243dri_pless
ductless11196313ductless
dustless9328353dustless
exitless1534883exitless
fatless103212203_fatless
feetless1137383feetless
fifteens1442753fifteens
fifties132111083fiftie_s
filmless1344553filmless
finless102810783fi_nless
fireless112810593fireless
fishless1436413fishless
fitness10299393fi_tness
footless113710803footless
fretless1138063fretless
frontless1235403frontless
frostless1235743frostless
fruitless1244163fruitless
giftees11306513gift_ees
grifters12389233grift_ers
gristles9189203gristle_s
guiltless1043023guiltless
gustless9287683gustless
gutless82610713_gutless
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
meritless1144593meri_tless
milkless1434773milkless
mindless11319443mindless
mirthless1443353mirthless
mistress10310703mistress
netless739863_netless
nifties102612503niftie_s
niftiest112910073niftiest
niftiness1236363niftiness
nightless1386073nightless
pastless102411203pastless
peltless10267373peltless
piffles15368763piffle_s
pileless1088623pileless
pilotless1143993pilotless
pintles94118723pintle_s
pipeless12107663pipeless
pithless13117023pithless
pitiless10127333pitiless
plotless10256793plotless
poetless1038723poetless
pointless1135703pointless
portless10310643portless
priceless1336883priceless
profitless1542763profitless
rafflers14317363rafflers
raffles133611843raffle_s
rafters103715633raft_ers
rainless8129703rainless
rankless12268233rankless
raptness1046733raptness
rattlers83510293rattlers
rattles73217303rattle_s
rayless10239003r_ayless
reckless14257973reckless
refiles104122423refile_s
reflets103513153ref_lets
reinless8139433reinless
resistless1043173resistless
restress82511773restress
riblets93412553ri_blets
richness1337433richness
rictuses1037563rictuses
riddlers10269103riddlers
riddles93215023riddle_s
riderless1044903riderless
ridleys11145783ri_dleys
rifest93114583rif__est
riffle124210233riffle__
riffled14338603riffle_d
riffler13328353riffle_r
rifle85518333rif_le__
rifled104115003rif_le_d
rifler94014263rif_le_r
riflery13345803rif_lery
riflips1234163rif_lips
rifted104115313rift_e_d
rifts85718643rift___s
rightness13117353rightness
riles55343643ri__le_s
rilles64725503ri_lle_s
rillets74216153ri_llets
riminess10510093riminess
rimples113114223rimple_s
ringlets92910233ringlets
rioters73615513riot_ers
ripeness1039363ripeness
ripplers12337113ripplers
ripples113513293ripple_s
ripplets12316733ripplets
rites54442553ri_t_e_s
ritters74020623ri_tters
ritzes154812943ri_tze_s
riverless1244943riverless
rivulets1174753rivulets
roadless937703roadless
rockless14297293rockless
rodless8310073r_odless
roofless11316733roofless
rootles73215633rootle_s
rootlets8308653rootlets
rufflers14347193rufflers
ruffles133512273ruffle_s
ruleless836633ruleless
rumpless12256543rumpless
rungless956733rungless
runless72810423r_unless
rustlers8339853rustlers
rustles73416413rustle_s
ruthless1135413ruthless
saltless8259343saltless
seatless83213003seatless
shirtless12266413shirtless
shitless11249243shitless
sifters103714793sift_ers
sighless1276553sighless
sightless1385923sightless
sinless73014213si_nless
skiffless19243053skiffless
skirtless13254423skirtless
slitless8268143slitless
softness1136433softness
spotless1037043spotless
strifeless1343213strifeless
swiftlets1542723swiftlets
swiftness1543653swiftness
tactless10288463tactless
taintless935733taintless
tentless8229843tentless
textless15245793textless
tideless9269083tideless
tieless72512563ti_eless
timeless10239543timeless
tipless92610063ti_pless
tireless82510263tireless
titles63719923ti_tle_s
tittles73413253tittle_s
triflers113110213trif_lers
trifles103814823trif_le_s
trustless955953trustless
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
wristlets1244473wristlets
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 Limit1461622576.68621860.9
3Display Results2572570.0932763.4
 (SQL Overall)1786912577.18524870.0
 
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.