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

138 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
pointless113571(None) 
jointless1634321jointless
printless1137521printless
countless1146372countless
jointress1643052jointress
lintless82710012_lintless
painless10108352pain_less
pintles94118732p_intle_s
poetless1038722po_etless
pointers103013722point_ers
pointes93216752point_e_s
pointiest1139622pointiest
pointlessly1662942pointlessly
portless10310642po_rtless
taintless935742taintless
tintless8239862_tintless
boltless10338283bo_ltless
bondless1148813bo_ndless
boneless10310213bo_neless
boonless10328353boon_less
bootless103410983bo_otless
boundless1235183boundless
brineless1136263brineless
chinless1337493chin_less
clientless1272493clientless
coatless1039693co_atless
cointers103616423coint_ers
costless10310003co_stless
countess103710053count_ess
dauntless1033663dauntless
doubtless1243313doubtless
downless1236363down_less
eventless1244603eventless
exitless1534883exi_tless
faintness1235833faintness
finless102810783_fin_less
footless113710803fo_otless
frontless1235403frontless
gainless9117413gain_less
giftless1245173_giftless
guiltless1043023guiltless
hiltless11297123_hiltless
hitless103211193_hi_tless
hornless1137363horn_less
inkless11348713__inkless
innless7288293__innless
jointers15289323joint_ers
kindless13289243_kindless
kingless13288693_kingless
kinless113310273_kin_less
lineless82711943_lineless
listless8269263_listless
loftless1135903lo_ftless
mindless11319443_mindless
moistness1146343moistness
moonless10278043moon_less
noiseless945553noiseless
nounless837253noun_less
painters103013033paint_ers
paintiest11310563paintiest
paneless102611773p_aneless
parentless1244463parentless
pastless102411203p_astless
peltless10267373p_eltless
penniless1144013penniless
pileless1088623p_ileless
pilotless1143993pilotless
pinkness1436513p_inkness
pinoles93418713p_inole_s
pintle83818263p_intle__
pintoes95117713p_intoe_s
pipeless12107663p_ipeless
pithless13117023p_ithless
pitiless10127333p_itiless
planless1036823plan_less
plantlets1145023plantlets
pleatless1134613pleatless
pliantness1263643pliantness
plotless10256793p_lotless
poetess938933po_et_ess
pointe84619313point_e__
pointed103813983point_e_d
pointedness1445093pointedness
pointelle1144583pointelle
pointelles1245013pointelles
pointer93814933point_e_r
pointier1038303pointie_r
pointmen1245423pointme_n
points85618533point___s
poitrels1035243poi_trels
pokiness14219863pokin__ess
poleless1089873po_leless
pontes83627853po_nt_e_s
popeless1288473po_peless
portress1038323po_rtress
pottles93816983po_ttle_s
powerless1444293powerless
priceless1336893priceless
princess12266813prin_cess
printers103214913print_ers
profitless1542763profitless
rainless8129713rain_less
reinless8139443rein_less
riftless1136943_riftless
rindless92510203_rindless
rootless83910443ro_otless
scentless1135113scentless
shiftless15265303shiftless
shirtless12266413shirtless
shitless11249243shi_tless
sinless73014213_sin_less
skinless12216973skin_less
skirtless13254423skirtless
slitless8268143sli_tless
soilless8279033soi_lless
songless9218823so_ngless
sonless72612613so_n_less
soundless1035533soundless
spineless1136133spineless
spinless10238703spin_less
spotless1037043spo__tless
spoutless1134243spo_utless
stingless1046463stingless
tentless8229843_tentless
toneless8610393to_neless
townless1135653town_less
veinless11136263vein_less
ventless11249053_ventless
voiceless1444223voiceless
waistless1235093waistless
windless123310863_windless
wineless112711173_wineless
wingless122910023_wingless
winless103212283_win_less
wintles103414983_wintle_s
witless103310983_wi_tless
woundless1334033woundless
zoneless1737823zo_neless

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.453394461.4
2DLD Change Limit1486411387.89018839.2
3Display Results1381380.0632190.5
 (SQL Overall)1786911388.40621257.6
 
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.