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

289 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
holeless118936(None) 
homeless131110131homeless
hopeless13118301hopeless
poleless1089871poleless
soleless8910031soleless
boltless10338282boltless
boneless10310212boneless
codeless112010112codeless
coreless103013832coreless
haleness11312622haleness
haltless11308442haltless
heelless11257652heelless
helmless1334272helmless
helpless1335062helpless
hideless12278712hideless
hiltless11297122hiltless
hiveless14227932hiveless
holiness112512502holiness
hollers103818232hol_lers
hoodless12289732hoodless
hoofless14258012hoofless
hookless151238362hookless
hoopless13279252hoopless
hornless1137362hornless
horseless1237212horseless
houseless1237462houseless
hueless1058822h_ueless
isleless834852isleless
loveless1168572loveless
moveless1367752moveless
noseless839512noseless
noteless839402noteless
pileless1088622pileless
popeless1288472popeless
ruleless836632ruleless
shoeless1137802sho_eless
shoreless1236632shoreless
soleness8814262soleness
toeless72612392to_eless
toneless8610392toneless
voteless1137492voteless
wholeness1545372wholeness
yokeless1535302yokeless
zoneless1737822zoneless
ageless8310343_ageless
alleles73812033allele_s
aweless1038723_aweless
baseless1099563baseless
beltless10297713beltless
blotless10347143blotless
bodiless1135913bodiless
boldness1136973boldness
boletes9316063bolete_s
bondless1148813bondless
boonless10328353boonless
bootless103410983bootless
bowelless1443833bowelless
bowless123310313bo_wless
careless102813633careless
childless1543813childless
clueless1035883clueless
coalless1038193coalless
coatless1039693coatless
coldness1137953coldness
coleuses1039713coleuses
colleens1036843colleens
collets93517903col_lets
colorless1145683colorless
cookless14258633cookless
cordless11299963cordless
costless10310003costless
coverless1436803coverless
coxless1637743co_xless
cureless10319703cureless
dateless9259963dateless
doneness9411513doneness
doorless936713doorless
dowerless1344013dowerless
downless1236363downless
edgeless1034883edgeless
eyeless1058053_eyeless
faceless13269173faceless
fadeless12258323fadeless
fameless13259203fameless
feeless103511103_feeless
filmless1344553filmless
fireless112810593fireless
flyless1335003_flyless
foamless13195843foamless
fogless1138193fo_gless
folles93820473fol_le_s
foodless12338383foodless
footless113710803footless
forceless1435723forceless
fordless12289003fordless
forelegs1236613forelegs
forkless15267433forkless
formless13248083formless
fumeless13236603fumeless
fuseless11237233fuseless
gateless9279953gateless
goalless935723goalless
godless938403go_dless
goneness9310763goneness
gormless11235443gormless
groveless13235363groveless
guileless1044253guileless
hairless1157413hairless
halfness1435563halfness
hallels103310133hal_lels
handleless1473123handleless
handless123512063handless
hapless123311333h_apless
harmless1337403harmless
hatless103813443h_atless
headless12289863headless
heatless113011463heatless
heedless12278813heedless
heelers103815623h_eelers
heirless1146053heirless
hellers103619833hel_lers
herbless1336663herbless
hillers103718733hil_lers
hipless12399923h_ipless
hitless103211193h_itless
hobblers15308513hobblers
hobbles143313783hobble_s
hokeyness1943803hokeyness
hokiness152510183hokiness
holders113715903hol_ders
holes84748653ho__le_s
holies94630033hol_ie_s
holiest104319623hol_iest
hollas94616903hol_l_as
holler93520613hol_le_r
hollies103420813hol_lies
holloas103814943hol_loas
holloes103818193hol_loes
holloos104013583hol_loos
hollos95320633hol_l_os
hollows134412333hol_lows
holsters113211943holsters
homeliest1448553homeliest
homeliness1545763homeliness
homeyness1745013homeyness
hominess132712453hominess
hondles113614523hondle_s
hooklets15217203hooklets
hopelessly1843083hopelessly
hopples142810713hopple_s
hosels94218603hosel__s
hostelers1246633hostelers
hostess103210243ho_stess
hostlers113310483hostlers
hoteliers1245803hoteliers
hotels94515503hotel__s
hotness1038613ho_tness
hotpress1344303hotpress
hoveled14209293hovele_d
hovels125413333hovel__s
hoverers14289023hoverers
howlers133312353ho_wlers
howlets13329223ho_wlets
hoyles12315013ho_yle_s
hugeness1237373hugeness
hullers103616263hul_lers
humpless15226333humpless
hurtless11307783hurtless
hymnless1632803hymnless
iceless9219963_iceless
idleness936843idleness
ireless72312243_ireless
jobless16237563jo_bless
joyless17226513jo_yless
keelless12236193keelless
laceless10239853laceless
legless838013__legless
lifeless11228143lifeless
limeless10249663limeless
lineless82711943lineless
loamless10235213loamless
loftless1135903loftless
lollers72713793lol_lers
loneness8512093loneness
lordless9277483lordless
lossless835473lossless
maleness10312313maleness
maneless102812343maneless
mateless102711293mateless
milkless1434773milkless
modelers1138463modelers
moneyless1444653moneyless
moonless10278043moonless
moreness10911573moreness
nameless10248373nameless
nobleness1147513nobleness
noiseless945553noiseless
normless10235923normless
nounless837253nounless
oarless73913373_oarless
oldness836403_oldness
omelets938333_omelets
oneness7512143_oneness
orbless937493_orbless
paleness10312983paleness
paneless102611763paneless
peltless10267373peltless
peopleless1441903peopleless
pipeless12107663pipeless
plotless10256793plotless
poetess938933po_etess
poetless1038723poetless
pollees93215333pol_lees
pollens93713303pol_lens
pollers93420023pol_lers
portless10310643portless
powerless1444293powerless
pulpless12224953pulpless
rhymeless1741673rhymeless
roadless937703roadless
rockless14297293rockless
rodless8310073ro_dless
rollers73117473rol_lers
roofless11316733roofless
rootless83910443rootless
saltless8259343saltless
scaleless1135513scaleless
scoreless1155603scoreless
selfless1135013selfless
shadeless1335733shadeless
shameless1435923shameless
shapeless1435563shapeless
shovelers15174943shovelers
showerless1642543showerless
smileless1134693smileless
smokeless1543553smokeless
soapless10278073soapless
sockless14267793sockless
sodaless936113sodaless
soilless8279033soilless
solerets839693solerets
soleuses838073soleuses
songless9218823songless
sonless72612613so_nless
soreness8914793soreness
soulless8218763soulless
soupless10268463soupless
styleless1243413styleless
tableless1145023tableless
tameless10259903tameless
tapeless10218643tapeless
thornless1243633thornless
thowless1434613tho_wless
tideless9269083tideless
tieless72512563_tieless
timeless10239543timeless
tireless82510263tireless
toadless936313toadless
tollers73217463tol_lers
tombless1236773tombless
toolless836343toolless
topless92511123to_pless
townless1135653townless
toyless10268713to_yless
treeless839283treeless
tubeless1037023tubeless
tuneless837913tuneless
useless7188423_useless
valueless1242843valueless
valveless1543163valveless
viceless1337983viceless
vileness1139983vileness
voiceless1444223voiceless
volleys13316643vol_leys
vowless13246603vo_wless
wageless1237173wageless
wakeless1536473wakeless
waveless1437483waveless
weldless12285813weldless
wheelless1543763wheelless
whelpless1742053whelpless
wifeless14277483wifeless
wineless112711173wineless
wireless11249633wireless
woeness1020211543wo_eness
woodless12278453woodless
wordless12258843wordless
workless15276803workless
yodelers1235673yodelers

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 Filter1786911461620.1731032896.0
2DLD Change Limit1461622898.32617554.9
3Display Results2892890.1262293.7
 (SQL Overall)1786912898.62520717.8
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.