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

208 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
pithless1311702(None) 
pathless13138041pathless
pitiless10127331pitiless
bathless13127382bathless
faithless1543902faithless
fishless1436412fishless
hitless103211192hit_less
mirthless1443352mirthless
nathless11127022nathless
pileless1088622pileless
pipeless12107662pipeless
pithiest132711442pithiest
pithiness1437562pithiness
ruthless1135412ruthless
sighless1276552sighless
wishless1435992wishless
witless103310982wit_less
aidless83612073ai_dless
aimless93610813ai_mless
airless73712043ai_rless
apishness1445753apishness
artless73712513art_less
ashless10318453_ashless
bibless11439173bi_bless
bushless1335813bushless
cashless1336773cashless
cithers124315773cith_ers
cithrens13355933cithrens
citoles9312553citole_s
dateless9259963dateless
deathless1335223deathless
depthless1542753depthless
dithers114016153dith_ers
epithets1345763epith_ets
exitless1534883exit_less
fatless103212203fat_less
filmless1344553filmless
finless102810783fi_nless
fireless112810593fireless
fitness10299393fit_ness
gateless9279953gateless
giftless1245173giftless
gutless82610713gut_less
hatless103813443hat_less
heathless1535593heathless
hideless12278713hideless
highness1536053highness
hiltless11297123hiltless
hipless12399923hi_pless
hiveless14227933hiveless
iceless9219963_iceless
inkless11348713_inkless
innless7288293_innless
ireless72312243_ireless
kindless13289243kindless
kingless13288693kingless
kinless113310273ki_nless
kithes135016653kith_e_s
kittles113012493kittle_s
kittlest12297573kittlest
lidless8309273li_dless
lifeless11228143lifeless
lightless1386073lightless
limbless12246313limbless
limeless10249663limeless
lineless82711943lineless
lintless82710013lintless
lipless9259553li_pless
listless8269263listless
liteness82213213liteness
litheness1247363litheness
lithest10513913lith_est
littles73212783little_s
littlest8309243littlest
matchless1644683matchless
mateless102711293mateless
matless93014043mat_less
milkless1434773milkless
mindless11319443mindless
mithers123516733mith_ers
mouthless1444713mouthless
natheless1244963natheless
netless739863net_less
nighness1236103nighness
nightless1386073nightless
noteless839403noteless
outbless1037963outbless
painless10108353painless
paneless102611773paneless
passless10247223passless
pastless102411203pastless
pathoses13412773pathoses
patness92912283pat_ness
peakless14236683peakless
peerless1037513peerless
pegless1038053p_egless
peltless10267373peltless
pettles93916483pettle_s
phthises1645723phthises
pickles153215443pickle_s
piddlers12359593piddlers
piddles114314273piddle_s
pieholes13168913piehole_s
piffles15368773piffle_s
piglets103311793pi_glets
piles74742613pi__le_s
pileus84514943pi__leus
pilotless1143993pilotless
pilules9510623pilule_s
pimples133012423pimple_s
pinholes131810663pinhole_s
pinkness1436513pinkness
pinoles93418713pinole_s
pintles94118733pintle_s
piolets93513193pi_olets
pipiness1238003pipiness
pishers123815753pish_ers
pishes114722103pish_e_s
pistoles102514723pistole_s
pitchers153211483pitchers
pitches143617753pitche_s
pitchiest1646703pitchiest
pithead13419593pith_ead
pitheads14338143pitheads
pithed124615613pith_e_d
pithier123010293pithie_r
piths105817543pith___s
pitiers93812653pit_iers
pities83828083pit_ie_s
pitilessly1542883pitilessly
pixiness1736093pixiness
pizzles17329273pizzle_s
planless1036823planless
playless1334863playless
plotless10256793plotless
plugless1133863plugless
poetless1038723poetless
pointless1135713pointless
poleless1089873poleless
popeless1288473popeless
portless10310643portless
poshness1356653poshness
potheens13266483potheens
pothers123818623poth_ers
potholes13312933pothole_s
pottles93816983pottle_s
prebless1236823prebless
priceless1336893priceless
printless1137523printless
pulpless12224953pulpless
pumpless14236373pumpless
punchless1643653punchless
puttyless1442013puttyless
pythoness1743733pythoness
ribless93410343ri_bless
richness1337433richness
riftless1136943riftless
rimless9369363ri_mless
rindless92510203rindless
riskless1235763riskless
sashless1136603sashless
shitless11249243shit_less
sightless1385923sightless
sinless73014213si_nless
sithens1039383sith_ens
slitless8268143slit_less
spiceless1335923spiceless
spineless1136133spineless
spinless10238703spi_nless
spittles1038333spittle_s
spotless1037043spot_less
teethless1243703teethless
tideless9269083tideless
tieless72512563ti_eless
timeless10239543timeless
tintless8239863tintless
tipless92610063ti_pless
tireless82510263tireless
titaness836723titaness
tithers104216733tith_ers
tithes94720213tith_e_s
titles63719923tit_le_s
tittles73413253tittle_s
toothless1244683toothless
truthless1244033truthless
viceless1337983viceless
viewless1434033viewless
vistaless1254573vistaless
vitalness1245413vitalness
vittles103211113vittle_s
voteless1137493voteless
wattless11268723wattless
wickless1736083wickless
wifeless14277483wifeless
wigless11359673wi_gless
windless123310863windless
wineless112711173wineless
wingless122910023wingless
winless103212283wi_nless
wireless11249633wireless
withers134417753with_ers
withes124620843with_e_s
withies133913543withie_s
withiest142411243withiest
witness103010013wit_ness
worthless1544923worthless
zipless18276303zi_pless
zithers193911973zith_ers

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.436409841.7
2DLD Change Limit1461622087.12620511.1
3Display Results2082080.0762736.8
 (SQL Overall)1786912087.63823395.0
 
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.