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

249 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
toolless83634(None) 
boonless10328352boonless
bootless103410982bootless
coalless1038192coalless
cookless14258632cookless
coolness1037742coolness
doorless936712doorless
foodless12338382foodless
footless113710802footless
goalless935722goalless
hoodless12289732hoodless
hoofless14258012hoofless
hookless151238362hookless
hoopless13279252hoopless
moonless10278042moonless
roofless11316732roofless
rootless83910442rootless
soilless8279022soilless
soulless8218762soulless
tailless8239082tailless
thowless1434612thowless
toadless936302toadless
toeless72612392t_oeless
tollers73217452t_ollers
tombless1236772tombless
toneless8610392toneless
toolers74416502too_lers
toothless1244682toothless
tootlers8289502tootlers
tootles72915602tootle_s
topless92511122t_opless
townless1135652townless
toyless10268712t_oyless
trollers83211202trollers
trolleys11315692trolleys
woodless12278452woodless
woollens1144092woollens
bloodless1234513bloodless
bloomless1342963bloomless
blotless10347143blotless
bodiless1135913bodiless
boltless10338283boltless
bondless1148813bondless
boneless10310213boneless
boodlers113710743boodlers
boodles103416043boodle_s
booklets14247123booklets
boomlets12246673boomlets
bootlegs11325873bootlegs
boulles93114123boulle_s
bowelless1443833bowelless
bowless123310313_bowless
broodless1235033broodless
browless1346653browless
coatless1039693coatless
codeless112010113codeless
collets93517903_collets
colorless1145683colorless
coolers93522493coo_lers
coolest9318643coo_lest
coolies93824963coolie_s
cordless11299963cordless
coreless103013833coreless
costless10310003costless
coxless1637743_coxless
cropless1237793cropless
doodlers10338843doodlers
doodles93614163doodle_s
doolees83711613doo_lees
doolies83920713doolie_s
downless1236363downless
drollest937353drollest
drollness1043623drollness
egoless836983ego_less
floorless1243793floorless
foamless13195843foamless
fogless1138193_fogless
folles93820473_folle_s
footlers113910793footlers
footles103715713footle_s
foozlers20346073foozlers
foozles19329543foozle_s
fordless12289003fordless
forkless15267433forkless
formless13248083formless
foulness11236653foulness
godless938403_godless
goodness1036253goodness
gormless11235443gormless
heelless11257653heelless
holeless1189363holeless
hollers103818233_hollers
homeless131110133homeless
hooklets15217203hooklets
hopeless13118303hopeless
hornless1137363hornless
jobless16237563_jobless
joyless17226513_joyless
keelless12236193keelless
knollers12255133knollers
knotless1264563knotless
loamless10235213loamless
loftless1135903loftless
lollers72713793_lollers
lordless9277483lordless
lossless835473lossless
loveless1168573loveless
mailless10248583mailless
mealless10288363mealless
mooleys1236863moo_leys
moonlets10247473moonlets
mootness1036753mootness
motorless1145723motorless
moveless1367753moveless
noodles83513193noodle_s
normless10235923normless
noseless839513noseless
noteless839403noteless
nounless837253nounless
oarless73913373_oarless
odorless934173odorless
oodles73517183_oodle_s
orbless937493_orbless
plotless10256793plotless
poetless1038723poetless
poleless1089873poleless
pollees93215333_pollees
pollens93713303_pollens
pollers93420023_pollers
poodles103013513poodle_s
poolers94217423poo_lers
poorness1036353poorness
popeless1288473popeless
portless10310643portless
roadless937693roadless
rockless14297293rockless
rodless8310073_rodless
rollers73117473_rollers
rootles73215633rootle_s
rootlets8308653rootlets
sailless82410363sailless
shoeless1137803shoeless
skilless12246753skilless
smogless1134053smogless
snowless1145613snowless
soapless10278073soapless
sockless14267793sockless
sodaless936113sodaless
soleless8910033soleless
songless9218823songless
sonless72612613_sonless
soupless10268463soupless
spotless1037043spotless
stollens835283stollens
stoolies8311083stoolie_s
strollers937523strollers
tableless1145023tableless
tackless14419483tackless
tactless10288463tactless
tailles72516463taille_s
tallest7317093t_allest
tallness837103tallness
tameless10259903tameless
tankless12267823tankless
tapeless10218643tapeless
taxless1436903t_axless
tearless848703tearless
tellers73717583t_ellers
tentless8229843tentless
termless1036233termless
textless15245793textless
thawless1434083thawless
thewless1433923thewless
tholes94919783tho_le_s
thornless1243633thornless
tideless9269083tideless
tieless72512563t_ieless
tillers73418733t_illers
timeless10239543timeless
tintless8239863tintless
tipless92610063t_ipless
tireless82510263tireless
toddlers10346953toddlers
toddles93211533toddle_s
togglers10276953togglers
toggles93710973toggle_s
toilers74116263t_oilers
toiles63923513t_oile_s
toilets74112913t_oilets
toles55147133t_o_le_s
tolled73819033t_olle_d
toller63819443t_olle_r
tolls54728433t_oll__s
tomalleys1441673tomalleys
tonlets73212503t_onlets
toolbars1044723toolbars
tooled74918903too_le_d
tooler63818613too_le_r
toolhead1244353toolhead
toolheads1343673toolheads
toolings9248473toolings
tools55325243too_l__s
toolsheds1342323toolsheds
toonies73719883toonie_s
tooters73818773too_ters
tootle62613813tootle__
tootled83511043tootle_d
tootler73511123tootle_r
tootses72910773tootse_s
topples113111653topple_s
tousles74113933tousle_s
touzles16359223touzle_s
townlets1134773townlets
trailless935963trailless
tramless1037503tramless
treeless839283treeless
trillers83613483trillers
trolled84312263trolle_d
troller73913173trolle_r
trolley10328753trolle_y
trollies8310233trollies
trollops1044803trollops
trolls64613943troll__s
tubeless1037023tubeless
tugless837383t_ugless
tuilles72411923tuille_s
tulles63218893t_ulle_s
tuneless837913tuneless
turfless1135533turfless
tuskless1234213tuskless
twigless1293663twigless
volleys13316643_volleys
voteless1137493voteless
vowless13246603_vowless
woolens10398843woo_lens
woolers104214023woo_lers
woolies104117363woolie_s
wooliest113011643wooliest
wooliness12147693wooliness
woolled1136643woolle_d
woollen1034723woolle_n
woollies1147413woollies
woolliest1235853woolliest
woolliness1343563woolliness
wordless12258843wordless
workless15276803workless
yokeless1535303yokeless
zoneless1737823zoneless
zoogleas1843373zoogleas

Search took 8 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 Limit1461622497.01620832.7
3Display Results2492490.1102263.6
 (SQL Overall)1786912497.28224538.7
 
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.