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

235 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
workless1527680(None) 
forkless15267431forkless
wordless12258841wordless
barkless14318022barkless
cookless14258632cookless
cordless11299962cordless
coreless103013832coreless
fordless12289002fordless
formless13248082formless
gormless11235442gormless
hookless151238362hookless
hornless1137362hornless
lordless9277482lordless
normless10235922normless
orbless937492_orbless
portless10310642portless
rockless14297292rockless
sockless14267792sockless
wardless12249302wardless
warless104015102war_less
wartless11279922wartless
wickless1736082wickless
wireless11249632wireless
woodless12278452woodless
workers144612692work_ers
wornness1136362wornness
worthless1544922worthless
airless73712043air_less
armless9369943_armless
artless73712513_artless
backless162910633backless
barbless12318713barbless
barless94317003bar_less
beakless14297383beakless
bodiless1135913bodiless
boltless10338283boltless
bondless1148813bondless
boneless10310213boneless
booklets14247123booklets
boonless10328353boonless
bootless103410983bootless
bowless123310313bo_wless
braless92910563_braless
browless1346653browless
careless102813633careless
carless95118493car_less
coalless1038193coalless
coatless1039693coatless
cockles153414643cockle_s
codeless112010113codeless
corkers134118853cork_ers
corkiest143114793corkiest
corkiness152810443corkiness
corslets1038273corslets
corulers1039773corulers
costless10310003costless
coxless1637743co_xless
cropless1237793cropless
cureless10319703cureless
darkles124011933darkle_s
darkness13247343darkness
doorless936713doorless
dorkiest133111253dorkiest
dorkiness14248053dorkiness
downless1236363downless
earless74316073ear_less
feckless17225783feckless
fernless1136063fernless
fireless112810593fireless
flockless1843163flockless
foamless13195843foamless
fogless1138193fo_gless
foodless12338383foodless
footless113710803footless
forceless1435723forceless
forelegs1236613forelegs
forkers144615783fork_ers
forkiest153812303forkiest
forkiness16268703forkiness
fortress1136753fortress
frockless1843453frockless
furless103210143fur_less
garbless11388253garbless
goalless935723goalless
godless938403go_dless
goriness9310753goriness
harmless1337403harmless
herbless1336663herbless
holeless1189363holeless
homeless131110133homeless
hoodless12289733hoodless
hoofless14258013hoofless
hooklets15217203hooklets
hoopless13279263hoopless
hopeless13118303hopeless
horseless1237213horseless
hurtless11307783hurtless
inkless11348713_inkless
ireless72312243_ireless
jobless16237563jo_bless
joyless17226513jo_yless
juryless1832983juryless
knockless1442443knockless
leakless12246983leakless
loamless10235213loamless
loftless1135903loftless
lornness836493lornness
lossless835473lossless
loveless1168573loveless
luckless14265893luckless
milkless1434773milkless
moonless10278043moonless
morales93619403morale_s
moreness10911573moreness
moveless1367753moveless
neckless14236433neckless
noseless839513noseless
noteless839403noteless
nounless837253nounless
oarless73913373_oarless
odorless934173odor_less
orles55326213_or_le_s
peakless14236683peakless
poetless1038723poetless
poleless1089873poleless
popeless1288473popeless
porkers134314933pork_ers
porkies133416493porkie_s
porkiest143513713porkiest
porkiness15249193porkiness
portress1038323portress
rankless12268233rankless
reckless14257973reckless
riskless1235763riskless
roadless937703roadless
rodless8310073ro_dless
roofless11316733roofless
rootless83910443rootless
scoreless1155603scoreless
shoreless1236633shoreless
soapless10278073soapless
sodaless936113sodaless
soilless8279033soilless
soleless8910033soleless
songless9218823songless
sonless72612613so_nless
soreness8914793soreness
soulless8218763soulless
soupless10268463soupless
suckless14288823suckless
tackless14419483tackless
tankless12267823tankless
termless1036233termless
thornless1243633thornless
tireless82510263tireless
toadless936313toadless
toeless72612393to_eless
tombless1236783tombless
toneless8610393toneless
toolless836343toolless
topless92511123to_pless
townless1135653townless
toyless10268713to_yless
turfless1135533turfless
tuskless1234213tuskless
verbless1336033verbless
voteless1137493voteless
vowless13246603vo_wless
wageless1237173wageless
wakeless1536473wakeless
warblers13319103warblers
warbles123215563warble_s
wardress12256163wardress
wariness11313213wariness
warmness1337063warmness
warslers11328073warslers
warsles103413643warsle_s
wattless11268723wattless
waveless1437483waveless
wayless13308243w_ayless
weakness1535353weakness
weariless1234763weariless
webless1237003w_ebless
weedless12287963weedless
weldless12285813weldless
whortles14306743whortle_s
wifeless14277483wifeless
wigless11359673w_igless
windless123310863windless
wineless112711173wineless
wingless122910023wingless
winkles143412773winkle_s
winless103212283w_inless
wiriness1138953wiriness
wishless1435993wishless
witless103310983w_itless
wobblers15327883wobblers
wobbles143412433wobble_s
woeness1020211543wo_eness
womanless1443383womanless
wonkiest1538943wonkiest
woolens10398843wo_olens
woolers104214023wo_olers
woollens1144093woollens
wordiest122311543wordiest
wordiness13138633wordiness
wordlessly1742843wordlessly
workbags1843013workbags
workdays1942903workdays
worked145314703work_e_d
worker134715113work_e_r
workflows2252173workflows
workings16337503workings
workload1643023workload
workloads1742743workloads
workmen1635933workme_n
workouts1544963workouts
works125621903work___s
workups1633613work_ups
workweek1742133workweek
workweeks1841753workweeks
worlds10568733wor_l_ds
wormers124012573wor_mers
wormiest13249543wormiest
worminess14127613worminess
worriers11257813worriers
worries104117133worrie_s
worsens104610263wor_sens
worses95522953wor_se_s
worsets105512843wor_sets
worsteds1234483worsteds
woundless1334033woundless
wryness13113983w_ryness
yokeless1535303yokeless
zoneless1737823zoneless

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.423422437.4
2DLD Change Limit1461622356.45322650.2
3Display Results2352350.0932526.9
 (SQL Overall)1786912356.96925640.8
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2025  |  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.