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

266 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
noseless83951(None) 
noiseless945551noiseless
noteless839401noteless
baseless1099562baseless
boneless10310212boneless
codeless112010112codeless
coreless103013832coreless
costless10310002costless
fuseless11237232fuseless
holeless1189362holeless
homeless131110132homeless
hopeless13118302hopeless
horseless1237212horseless
houseless1237462houseless
lossless835472lossless
loveless1168572loveless
moveless1367752moveless
nameless10248372nameless
normless10235922normless
nosiness83211392nosiness
nounless837252nounless
poleless1089872poleless
popeless1288472popeless
soleless8910032soleless
toeless72612392to_eless
toneless8610392toneless
useless7188422_useless
voteless1137492voteless
yokeless1535302yokeless
zoneless1737822zoneless
ageless8310343_ageless
ashless10318453_ashless
assetless943573assetless
aweless1038723_aweless
baseness10910943baseness
bodiless1135913bodiless
boltless10338283boltless
bondless1148813bondless
boonless10328353boonless
bootless103410983bootless
bowelless1443833bowelless
bowless123310313bo_wless
bushless1335813bushless
careless102813633careless
cashless1336773cashless
causeless1135193causeless
ceaseless1135733ceaseless
closeness1137613closeness
clueless1035883clueless
coalless1038193coalless
coatless1039693coatless
cookless14258633cookless
cordless11299963cordless
corselets1147313corselets
cosiness103214283cosiness
coverless1436803coverless
coxless1637743co_xless
cureless10319703cureless
dateless9259963dateless
doneness9411513doneness
doorless936713doorless
dowerless1344013dowerless
downless1236363downless
dustless9328343dustless
edgeless1034883edgeless
eyeless1058053_eyeless
faceless13269173faceless
fadeless12258323fadeless
fameless13259203fameless
feeless103511103_feeless
fireless112810593fireless
fishless1436413fishless
foamless13195843foamless
fogless1138193fo_gless
foodless12338383foodless
footless113710803footless
forceless1435723forceless
fordless12289003fordless
forelegs1236613forelegs
forkless15267433forkless
formless13248083formless
frostless1235743frostless
fumeless13236603fumeless
gasless8319013gas_less
gateless9279953gateless
goalless935723goalless
godless938403go_dless
goneness9310763goneness
gormless11235443gormless
gospelers1273683gospelers
groveless13235363groveless
gustless9287683gustless
hideless12278713hideless
hiveless14227933hiveless
hoodless12289733hoodless
hoofless14258013hoofless
hookless151238363hookless
hoopless13279253hoopless
hornless1137363hornless
hosels94218603hosel__s
hostelers1246633hostelers
hostess103210233hos_tess
hostlers113310483hostlers
hueless1058823_hueless
iceless9219963_iceless
ireless72312243_ireless
isleless834853isleless
issueless942393issueless
jobless16237563jo_bless
jostlers15357683jostlers
jostles143411143jostle_s
joyless17226513jo_yless
knockless1442443knockless
knotless1264563kno_tless
laceless10239853laceless
lifeless11228143lifeless
limeless10249663limeless
lineless82711943lineless
listless8269263listless
loamless10235213loamless
loftless1135903loftless
loneness8512093loneness
looseness937463looseness
lordless9277483lordless
losels64714583losel__s
lostness837683lostness
maneless102812343maneless
massless10277113massless
mastless102610023mastless
mateless102711293mateless
menseless1145203menseless
modelers1138463modelers
moneyless1444653moneyless
moonless10278043moonless
moreness10911573moreness
napless93110283n_apless
natheless1244963natheless
nathless11127023nathless
neckless14236433neckless
needless9308333needless
nerveless1243933nerveless
nestlers8359223nestlers
nestles73015463nestle_s
netless739863n_etless
newsless1134533newsless
niceness1039843niceness
nobblers12318563nobblers
nobbles114014523nobble_s
nobleness1147513nobleness
nobles83319723no_ble_s
noblesse1044533no_blesse
noblest93613563no_blest
noddles92911293noddle_s
nodules8269703nodule_s
noels56418703no_el__s
noesises838503noesises
noiselessly1452483noiselessly
noisiness948343noisiness
nombles113212343nomble_s
nonclass1046243nonclass
nonelect10410283nonelect
nonselves1246503nonselves
nonsenses948343nonsenses
noodles83513193noodle_s
nopales93812523nopale_s
nosebags1143593nosebags
nosebleed1242233nosebleed
nosebleeds1351413nosebleeds
nosegays1243303nosegays
noselike12158573noselike
noses55435643nos__e_s
noshers103614323nos_hers
noshes96618233nos_he_s
nosiest73415673nos_iest
notedness1047323notedness
novelise1137953novelise
novelises1247373novelises
novelist1149453novelist
novelists1245933novelists
novellas1176343novellas
novels95512503novel__s
nowness1037033no_wness
nozzles15276303nozzle_s
nudeness936733nudeness
oarless73913373_oarless
omelets938333_omelets
oneness7512143_oneness
opposeless1441673opposeless
orbless937493_orbless
ostlers72911203_ostlers
paneless102611763paneless
passless10247223passless
pastless102411203pastless
pileless1088623pileless
pipeless12107663pipeless
poetess938933po_etess
poetless1038723poetless
portless10310643portless
poshness1356643poshness
posoles9314883posole_s
possess9419113pos_sess
powerless1444293powerless
restless82713163restless
riskless1235763riskless
roadless937693roadless
rockless14297293rockless
rodless8310073ro_dless
roofless11316733roofless
rootless83910443rootless
roselles8310713roselles
rosiness82613173rosiness
ruleless836633ruleless
rustless83510233rustless
sashless1136603sashless
scoreless1155603scoreless
senseless945973senseless
sexless1467243__sexless
shoeless1137803shoeless
shoreless1236633shoreless
smokeless1543553smokeless
snowless1145613sno_wless
soapless10278073soapless
sockless14267793sockless
sodaless936113sodaless
soilless8279023soilless
soleness8814263soleness
songless9218823songless
sonless72612613so_nless
soreness8914793soreness
soulless8218763soulless
soupless10268463soupless
tameless10259903tameless
tapeless10218643tapeless
tasteless935673tasteless
tideless9269083tideless
tieless72512563_tieless
timeless10239543timeless
tireless82510263tireless
toadless936303toadless
tombless1236773tombless
toolless836343toolless
topless92511123to_pless
townless1135653townless
toyless10268713to_yless
treeless839283treeless
tubeless1037023tubeless
tuneless837913tuneless
tuskless1234213tuskless
vestless11258843vestless
viceless1337983viceless
voiceless1444223voiceless
vowless13246603vo_wless
wageless1237173wageless
wakeless1536473wakeless
waveless1437483waveless
wifeless14277483wifeless
wineless112711173wineless
wireless11249633wireless
wiseness112010753wiseness
wishless1435993wishless
woeness1020211543wo_eness
woodless12278453woodless
wordless12258843wordless
workless15276803workless
yodelers1235673yodelers
zestless17247433zestless

Search took 7 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.1561145455.1
2DLD Change Limit1461622666.61022112.3
3Display Results2662660.1102418.2
 (SQL Overall)1786912666.87625987.6
 
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.