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

136 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
pleatless113461(None) 
beatless103311592_beatless
heatless113011462_heatless
leadless9248792_leadless
leafless11246572_leafless
leakless12246982_leakless
meatless103410862_meatless
peakless14236682p_eakless
peltless10267372p_eltless
planless1036832pl_anless
playless1334862pl_ayless
pleaters103613792pleat_ers
pleathers1446452pleathers
plotless10256792pl_otless
poetless1038722poe_tless
seatless83213002_seatless
wheatless1534002wheatless
alertness946053alertness
beakless14297383_beakless
beamless12327003_beamless
beltless10297713_beltless
bleakness1543593bleakness
bleaters103412323bleat_ers
blotless10347153bl_otless
breadless1235943breadless
breathless1543533breathless
clawless1334123cl_awless
cleanness1144973cleanness
clearness1135633clearness
clientless1272493clientless
coatless1039693_coatless
crestless1146783crestless
deathless1335223_deathless
debtless1135653_debtless
dreamless1243513dreamless
earless74316073__earless
electress1146123electress
eventless1244603eventless
fatless103212203__fatless
fearless1137873_fearless
feastless1235043_feastless
feetless1137383_feetless
flagless1235403fl_agless
flapless1335343fl_apless
flatlets1147373fl_atlets
flatness1138153fl_atness
flawless1434503fl_awless
fleckless1842893fleckless
fleetness1244753fleetness
fleshless1543993fleshless
fretless1138063fre_tless
gearless937373_gearless
glebeless1242953glebeless
greatness1036903greatness
hatless103813443__hatless
headless12289863_headless
heartless1236393_heartless
heathless1535593_heathless
idealess935653idea_less
idealless1042953idealless
kleagles1343143kleagle_s
lawless1037033_l_awless
leaflets11244813_leaflets
leanness837373_leanness
leathers114215083_leathers
legless838013_le_gless
lensless835583_lensless
lintless82710013_lintless
listless8269263_listless
loamless10235213_loamless
loftless1135903_loftless
matless93014043__matless
mealless10288363_mealless
neatness839153_neatness
netless739863_ne_tless
oleates7417833oleat_e_s
parentless1244463parentless
pastless102411203p_astless
pathless13138043p__athless
patness92912283p__atness
pearlers1039033p_earlers
peartness1137773p_eartness
peatiest103118813p_eatiest
peerless1037513p_eerless
pegless1038053p_e_gless
pertness10310093p_ertness
pestles93217693p_estle_s
pettles93916483p_ettle_s
pileless1088623pile__less
pillarless1242543pillarless
pilotless1144003pilotless
placeless1335613placeless
plantlets1145033plantlets
platelets1165763pl_atelets
platens94213983pl_at_ens
platers93924093pl_at_ers
plates85432243pl_at_e_s
platies93722543pl_atie_s
platiest103216093pl_atiest
platters103415283pl_atters
playlets1334903pl_aylets
pleaches153210433pleache_s
pleaders113210193plea_ders
pleasers104010293plea_sers
pleases94515483plea_se_s
pleated103816633pleat_e_d
pleater93916333pleat_e_r
pleather1356653pleathe_r
pleats85218593pleat___s
plenties10314693plentie_s
pliantness1263653pliantness
plugless1133863pl_ugless
poetess938933poe_t_ess
pointless1135713pointless
poleless1089873pole__less
portless10310643p_ortless
prealters1147773prealters
prebless1236823pre_bless
prestress1138133prestress
printless1137533printless
relentless1043703relentless
restless82713163_restless
scentless1135113scentless
seamless10238723_seamless
sheetless1235823sheetless
sleepless1144553sleepless
slitless8268143sl_itless
talentless1042803talentless
tearless848713_tearless
tentless8229843_tentless
textless15245793_textless
treadless1036003treadless
ventless11249053_ventless
vestless11258843_vestless
yeastless1234053_yeastless
zestless17247433_zestless

Search took 9 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 Filter1786911486410.436409841.7
2DLD Change Limit1486411367.75019179.5
3Display Results1361360.0632158.7
 (SQL Overall)1786911368.24921662.1
 
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.