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

240 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
pipeless1210766(None) 
pileless1088621pileless
popeless1288471popeless
fireless112810592fireless
hideless12278712hideless
hipless12399922hip_less
hiveless14227932hiveless
hopeless13118302hopeless
iceless9219962_iceless
ireless72312242_ireless
lifeless11228142lifeless
limeless10249662limeless
lineless82711942lineless
lipless9259552lip_less
paneless102611762paneless
paperless1345832paperless
pipiness1238002pipiness
pithless13117022pithless
pitiless10127332pitiless
poleless1089872poleless
priceless1336882priceless
ripeness1039362ripeness
spiceless1335922spiceless
spineless1136132spineless
tapeless10218642tapeless
tideless9269082tideless
tieless72512562ti_eless
timeless10239542timeless
tipless92610062tip_less
tireless82510262tireless
viceless1337982viceless
wifeless14277482wifeless
wineless112711172wineless
wireless11249632wireless
zipless18276302zip_less
ageless8310343_ageless
aidless83612073ai_dless
aimless93610813ai_mless
airless73712043ai_rless
aweless1038723_aweless
baseless1099563baseless
bibless11439173bi_bless
boneless10310213boneless
brineless1136243brineless
capelets1268603capelets
capless114312763cap_less
careless102813633careless
clueless1035883clueless
codeless112010113codeless
coreless103013833coreless
crimeless1335063crimeless
cupelers1266733cupelers
cureless10319703cureless
dateless9259963dateless
dipoles101013753dipole_s
direness9311303direness
dripless1135243drip_less
edgeless1034883edgeless
eyeless1058053_eyeless
faceless13269173faceless
fadeless12258323fadeless
fameless13259203fameless
feeless103511103_feeless
fiberless1444453fiberless
filmless1344553filmless
fineness11310643fineness
finless102810783fi_nless
fipples14298653fipple_s
fishless1436413fishless
fumeless13236603fumeless
fuseless11237233fuseless
gapless10349993gap_less
gateless9279953gateless
giftless1245173giftless
guideless1143843guideless
guileless1044253guileless
hapless123311333hap_less
hiltless11297123hiltless
hipness12277383hip_ness
hitless103211193hi_tless
holeless1189363holeless
homeless131110133homeless
hueless1058823_hueless
idealess935653_idealess
inkless11348713_inkless
innless7288293_innless
isleless834853isleless
juiceless1843253juiceless
kindless13289243kindless
kingless13288693kingless
kinless113310273ki_nless
laceless10239853laceless
libelees10227213libelees
libelers10238623libelers
lidless8309273li_dless
likeness12229863likeness
limbless12246313limbless
linerless936333linerless
lintless82710013lintless
listless8269263listless
liteness82213213liteness
liveness112411393liveness
loveless1168573loveless
maneless102812343maneless
mateless102711293mateless
milkless1434773milkless
mindless11319443mindless
moveless1367753moveless
nameless10248373nameless
napless93110283nap_less
niceness1039843niceness
nipples11319663nipple_s
noiseless945553noiseless
noseless839513noseless
noteless839403noteless
painless10108343painless
paleness10312983paleness
paperers122410453paperers
papules112411573papule_s
passless10247223passless
pastless102411203pastless
pathless13138043pathless
peakless14236683peakless
peelers93615593p_eelers
peeress939503p_eeress
peerless1037513peerless
pegless1038053p_egless
peles75738083__pele_s
peltless10267373peltless
peopleless1441913peopleless
pickles153215443pickle_s
piddlers12359593piddlers
piddles114314273piddle_s
piecers114112253pi_ecers
pieces104217273pi_ece_s
piffles15368763piffle_s
piglets103311793pi_glets
piles74742613pi__le_s
pileus84514943pi__leus
pilotless1143993pilotless
pilules9510623pilule_s
pimples133012423pimple_s
pinenes93416673pinene_s
pinkness1436513pinkness
pinoles93418703pinole_s
pintles94118723pintle_s
piolets93513193pi_olets
pipages1289423pipage_s
pipals104213643pipal__s
pipeages1336423pipeages
pipefish1844533pipefish
pipefuls1543753pipefuls
pipelike16166693pipelike
pipeline12149503pipeline
pipelines13178353pipelines
pipers104318663pip__ers
pipes96030143pip__e_s
pipestems1542833pipestems
pipets105714773pip__ets
pipettes1237563pipettes
pipiest113114493pip_iest
pixels15478533pixel__s
pixiness1736093pixiness
pizzles17329273pizzle_s
placeless1335613placeless
planless1036813planless
playless1334863playless
plotless10256793plotless
plugless1133863plugless
poetess938933p_oetess
poetless1038723poetless
pointless1135703pointless
popples103011873popple_s
portless10310643portless
powerless1444293powerless
prebless1236823prebless
precess11310863p_recess
prepress12137983prepress
primeness1338653primeness
printless1137513printless
pulpless12224953pulpless
pumpless14236373pumpless
pureness101110183pureness
ribless93410343ri_bless
riderless1044903riderless
rifeness1138583rifeness
riftless1136943riftless
rimless9369363ri_mless
rindless92510193rindless
ripeners1036833ripeners
ripplers12337113ripplers
ripples113513293ripple_s
ripplets12316733ripplets
riskless1235763riskless
riverless1244943riverless
ruleless836633ruleless
sapless93313443sap_less
shapeless1435563shapeless
shipless13277693ship_less
shoeless1137803shoeless
sighless1276553sighless
sinewless1244363sinewless
sinless73014213si_nless
slipless10246993slip_less
smileless1134693smileless
soleless8910033soleless
spaceless1335733spaceless
spielers10319653spi_elers
spikelets1553393spikelets
spinless10238703spi_nless
stripeless1243283stripeless
tameless10259903tameless
tintless8239863tintless
tipplers12336353tipplers
tipples112811253tipple_s
toeless72612393_toeless
toneless8610393toneless
topless92511123top_less
treeless839283treeless
tubeless1037023tubeless
tuneless837913tuneless
useless7188423_useless
viewless1434033viewless
vileness1139983vileness
voiceless1444223voiceless
voteless1137493voteless
wageless1237173wageless
wakeless1536473wakeless
waveless1437483waveless
wickless1736083wickless
wideness12259473wideness
wigless11359673wi_gless
windless123310863windless
wingless122910023wingless
winless103212283wi_nless
wiseness112010753wiseness
wishless1435993wishless
witless103310983wi_tless
yokeless1535303yokeless
zoneless1737823zoneless

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.423422437.4
2DLD Change Limit1461622407.39019778.3
3Display Results2402400.0932580.6
 (SQL Overall)1786912407.90622601.9
 
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.