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

273 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
planless103682(None) 
playless1334861playless
clawless1334122clawless
flagless1235402flagless
flapless1335342flapless
flawless1434502flawless
glandless1134162glandless
landless94011172_landless
lawless1037032_lawless
manless93012932_manless
painless10108352painless
paneless102611772p_aneless
peakless14236682peakless
placeless1335612placeless
plainness1155192plainness
planeness1138162planeness
planers94517952plan_ers
planes85028082plan_e_s
planets93914082plan_ets
planlessly1542812planlessly
planners10399942planners
planters102915332planters
plantlets1145022plantlets
playlets1334902playlets
pleatless1134612pleatless
plotless10256792plotless
plugless1133862plugless
spanless10247362spanless
awless939263__awless
awnless1035923_awnless
barless94317003_barless
beakless14297383beakless
beamless12327003beamless
beatless103311593beatless
bladeless1234303bladeless
blameless1334733blameless
blandest113811043blandest
blandness1235973blandness
blankest14439063blankest
blankets14356503blankets
blankness1544673blankness
blotless10347153blotless
boonless10328353boonless
brainless1136413brainless
braless92910563bra_less
brandless1236133brandless
capless114312763_capless
carless95118493_carless
chadless1436403chadless
chinless1337493chinless
clangers114312343clangers
classless1143843classless
cleanness1144973cleanness
clueless1035883clueless
coalless1038193coalless
coatless1039693coatless
downless1236363downless
earless74316073_earless
fangless1237663_fangless
fatless103212203_fatless
fearless1137873fearless
fernless1136063fernless
finless102810783_finless
flameless1435353flameless
flanes94522423flan_e_s
flangers123311373flangers
flanges113413273flange_s
flankers15349303flankers
flannels1134843flannels
flatlets1147373flatlets
flatness1138153flatness
flyless1335003fl_yless
foamless13195843foamless
gainless9117413gainless
gapless10349993_gapless
gasless8319013_gasless
gearless937373gearless
giantess933893giantess
gladness1036153gladness
glancers11408003glancers
glances104113143glance_s
glanders103811513glanders
glandes95413833glande_s
glassless1043873glassless
goalless935723goalless
grainless1035903grainless
gunless8299633_gunless
haltless11308443haltless
handless123512063_handless
hapless123311333_hapless
hatless103813443_hatless
headless12289863headless
heatless113011463heatless
hornless1137363hornless
hymnless1632803hymnless
illness736473illn_ess
innless7288293_innless
jagless1537103_jagless
jawless1745653_jawless
kinless113310273_kinless
laceless10239853_laceless
ladlers84613573_ladlers
ladles74619543_ladle_s
lancers93616643_lancers
lances84824103_lance_s
lancets93411163_lancets
landers84026223_landers
landlers94312833_landlers
lanes54946793_lan_e_s
langleys1245103_langleys
lankest112714113_lankest
lankness12237043_lankness
lanners73618333_lanners
largess8408913_largess
laxness1436043_laxness
leadless9248793leadless
leafless11246573leafless
leakless12246983leakless
leanness837373leanness
legless838013_legless
lensless835583_lensless
lidless8309273_lidless
lineless82711943_lineless
lintless82710013_lintless
lipless9259553_lipless
loamless10235213loamless
maneless102812343_maneless
matless93014043_matless
mealless10288363mealless
meanness1037183meanness
meatless103410863meatless
moonless10278043moonless
napless93110283_napless
nounless837253nounless
oarless73913373_oarless
oldness836403oldn_ess
ovalness1134673ovalness
padles95221123p_adle_s
paleness10312993paleness
pales75753803p_a_le_s
palest83926223p_a_lest
palets85122313p_a_lets
pallets93919303p_allets
panders103423743p_anders
panels84716523p_an_els
panes76148693p_an_e_s
pangens103112073p_angens
paniers94717333p_aniers
panners93621273p_anners
pannes85522853p_anne_s
panzers184012013p_anzers
parles86334413p_arle_s
parleys125212383p_arleys
passless10247223passless
pastless102411203pastless
pathless13138043pathless
patness92912283p_atness
pearlers1039033pearlers
peerless1037513peerless
pegless1038053p_egless
peltless10267373peltless
penniless1144013penniless
pileless1088623pileless
pillarless1242543pillarless
pilotless1143993pilotless
pipeless12107663pipeless
pithless13117023pithless
pitiless10127333pitiless
placers114515263pla_cers
places104323703pla_ce_s
placets113911223pla_cets
plackets1646583plackets
plages94520153pla_ge_s
plaguers11286503plaguers
plagues103311063plague_s
plaices11411143plaice_s
plainest10313613plainest
plaiters103512633plaiters
planches153111863planches
planchets16236743planchets
plane74929143plan_e__
planed94420913plan_e_d
planer84122663plan_e_r
planet84228353plan_e_t
plangent1138803plangent
planish12412063plan_ish
planked143512283planke_d
planks124116753plan__ks
plankters1544583plankters
planned103810153planne_d
planner93511633planne_r
plans75731273plan___s
planted103516123plante_d
planter94017813plante_r
plantlet10310013plantle_t
plants84921803plan__ts
plaques18317893plaque_s
plashers133813453plashers
plashes124417393plashe_s
plasters103518133plasters
platelets1165763platelets
platens94213983pla_tens
platers93924093pla_ters
plates85432243pla_te_s
platies93722543platie_s
platiest103216093platiest
platters103415283platters
players124313763pla_yers
playlet1239523playle_t
playlist1347573playlist
playlists1444783playlists
playpens1534073playpens
pliantness1263643pliantness
plinkers14309403plinkers
plunders11329843plunders
plungers11379413plungers
plunges104011623plunge_s
plunkers14328343plunkers
poetless1038723poetless
pointless1135713pointless
poleless1089873poleless
popeless1288473popeless
portless10310643portless
prancers123210343prancers
prances113618783prance_s
prebless1236823prebless
princess12266813princess
printless1137523printless
pulpless12224953pulpless
pumpless14236373pumpless
rainless8129713rainless
rankless12268243_rankless
rayless10239003_rayless
realness8410443realness
reinless8139443reinless
roadless937703roadless
runless72810423_runless
saltless8259343saltless
sandless93212343_sandless
sapless93313443_sapless
scarless10189053scarless
seamless10238723seamless
seatless83213003seatless
sinless73014213_sinless
skinless12216973skinless
slanders94014023slanders
slipless10246993slipless
slitless8268143slitless
slyness1035263slyn_ess
snapless10287463snapless
soapless10278073soapless
sonless72612613_sonless
spinless10238703spinless
stainless9176503stainless
starless81610843starless
sunless73013693_sunless
tallness837103tallness
tankless12267823_tankless
taxless1436913_taxless
tearless848713tearless
thankless1633203thankless
thawless1434083thawless
toadless936313toadless
townless1135653townless
tramless1037503tramless
unless62413073__unless
uplanders1234863uplanders
veinless11136263veinless
wanness102610683_wanness
warless104015103_warless
wayless13308243_wayless
winless103212283_winless
womanless1443383womanless

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.420425454.8
2DLD Change Limit1461622737.11020557.2
3Display Results2732730.1102481.8
 (SQL Overall)1786912737.64023388.9
 
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.