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

298 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
tramless103750(None) 
armless9369942ar_mless
beamless12327002beamless
braless92910562bra_less
brimless1235272brimless
dreamless1243512dreamless
foamless13195842foamless
frameless1435532frameless
harmless1337402harmless
loamless10235212loamless
rayless10239002_rayless
rimless9369362_rimless
seamless10238722seamless
strapless1135792strapless
tameless10259902t_ameless
taxless1436912t_axless
tearless848712tearless
termless1036232termless
thawless1434082thawless
toadless936312toadless
traceless11228642traceless
trackless15246722trackless
trailers82912922trailers
trailless935962trailless
tramells10327832tramells
tramels93812492tram_els
trammels12295412trammels
trampers123210392trampers
tramplers13305882tramplers
tramples122610202trample_s
trawlers113310202trawlers
trawleys14284382trawleys
treadless1036002treadless
treeless839282treeless
trimness1067562trimness
aimless93610813_aimless
arables91814973arable_s
arames84622573aram_e_s
armlets94610063ar_mlets
artless73712513ar_tless
awless939263__awless
barbless12318713barbless
barkless14318023barkless
barless94317003_barless
beakless14297383beakless
beatless103311593beatless
blameless1334733blameless
bractless1335543bractless
brainless1136403brainless
brakeless1544993brakeless
brambles14308973bramble_s
brandless1236123brandless
brawlers13408643brawlers
breadless1235943breadless
browless1346653browless
camlets114314623_camlets
capless114312763_capless
careless102813633careless
carless95118493_carless
chadless1436403chadless
charmless1633583charmless
clawless1334123clawless
coalless1038193coalless
coatless1039693coatless
cradlers11309203cradlers
cradles103114133cradle_s
crambes1339963crambe_s
crammers14369353crammers
crawlers13309013crawlers
crewless1335413crewless
crimeless1335063crimeless
cropless1237793cropless
drabness1135803drabness
drawlers12307313drawlers
dripless1135243dripless
earless74316073_earless
fameless13259203_fameless
fatless103212203_fatless
fearless1137873fearless
filmless1344553filmless
flagless1235403flagless
flameless1435353flameless
flapless1335343flapless
flawless1434503flawless
formless13248083formless
frailest1139493frailest
frailness1236543frailness
framers125113823fram_ers
frames115119863fram_e_s
fretless1138063fretless
gapless10349993_gapless
garbless11388253garbless
gasless8319013_gasless
gearless937373gearless
goalless935723goalless
gormless11235443gormless
graceless12226893graceless
gradeless11236703gradeless
grainless1035893grainless
grammes123611323gramme_s
grassless1034303grassless
grateless10277583grateless
graveless13226693graveless
grayness1235933grayness
grimness1175993grimness
gumless10228273_gumless
hamlets123211403_hamlets
hapless123311333_hapless
hatless103813443_hatless
headless12289863headless
heatless113011463heatless
helmless1334273helmless
ireless72312243ir_eless
jagless1537103_jagless
jawless1745653_jawless
lawless1037033_lawless
leadless9248793leadless
leafless11246573leafless
leakless12246983leakless
manless93012933_manless
matless93014043_matless
mealless10288363mealless
meatless103410863meatless
nameless10248373_nameless
napless93110283_napless
normless10235923normless
oarless73913373_oarless
oracles93212423oracle_s
oratress834553oratress
orbless937493or_bless
peakless14236683peakless
planless1036813planless
playless1334863playless
prebless1236823prebless
primness1276763primness
railers74420663_railers
rainless8129703_rainless
rales54947493_ra_le_s
ramblers124010373_ramblers
rambles113118313_ramble_s
ramees84620893_ram_ees
ramets83517393_ram_ets
ramies84630463_ramie_s
ramjets1635163_ramjets
rammers113715043_rammers
rankless12268233_rankless
rawness1038153_rawness
ribless93410343_ribless
roadless937703roadless
rodless8310073_rodless
rumpless12256543_rumpless
runless72810423_runless
samlets93813553_samlets
sapless93313443_sapless
scarless10189053scarless
scumless1254993scumless
seatless83213003seatless
shameless1435923shameless
snapless10287463snapless
soapless10278073soapless
spanless10247363spanless
stampless1334543stampless
starless81610843starless
stemless1036653stemless
streamlets1243073streamlets
sumless92611123_sumless
tables84524893t_able_s
tablets94714383t_ablets
tackless14419483tackless
tactless10288463tactless
tailers73720183t_ailers
tailless8239083tailless
talers64628143t_a_lers
tales55451373t_a_le_s
tallest7317093t_allest
tallness837103t_allness
tamales93216153t_amale_s
tameness102411253t_ameness
tamers84224033t_am_ers
tames75242013t_am_e_s
tamest85721293t_am_est
tamises92715973t_amises
tampers113516743t_ampers
tankless12267823tankless
tapeless10218643tapeless
tartlets8289663tartlets
tartness82210133tartness
teazles16308923teazle_s
tentless8229843tentless
textless15245793textless
thalers106212263tha_lers
thankless1633203thankless
thewless1433923thewless
thowless1434613thowless
threadless1442473threadless
thumbless1643433thumbless
tideless9269083tideless
tieless72512563t_ieless
timeless10239543timeless
tintless8239863tintless
tipless92610063t_ipless
tireless82510263tireless
toeless72612393t_oeless
tombless1236783tombless
toneless8610393toneless
toolless836343toolless
topless92511123t_opless
townless1135653townless
toyless10268713t_oyless
tracers94917843tra_cers
traces85329933tra_ce_s
tracheas13410273tracheas
trachles13311753trachle_s
trackers143512853trackers
traders84316953tra_ders
trades75724503tra_de_s
trailed83415673traile_d
trailer73015393traile_r
trails64622513trail__s
trainees82712063trainees
trainers83114643trainers
traipses1036873traipses
traitress944403traitress
tramcars1245233tramcars
tramel84113713tram_e_l
trameled11309073trameled
tramell9398703tram_ell
tramline10311383tramline
tramlines1139843tramlines
trammed123810713tramme_d
trammel11357663tramme_l
trammelers1442513trammelers
tramped124312433trampe_d
tramper113812163trampe_r
trampiest13227903trampiest
trampish1535653trampish
trample11299703trample__
trampled13247903trample_d
trampler12278013trample_r
tramps105114453tram__ps
trams75327673tram___s
tramways1643723tramways
trances93919643trance_s
trapes85024463tra_pe_s
trapeses1039153tra_peses
trapnest10310923trapnest
trapnests1144433trapnests
trappers123711043trappers
trashers113013643trashers
trashes104119263trashe_s
trass56226473tra___ss
trasses74819323trasse_s
travelers12266773travelers
travels104711293tra_vels
traves94222743tra_ve_s
trawled113411523trawle_d
trawler104011903trawle_r
trawley13317303trawle_y
trawlnets1242843trawlnets
trawls94412393trawl__s
treacles1039703treacle_s
treadlers1045893treadlers
treadles939703treadle_s
trebles9311443treble_s
tremblers1334483tremblers
trembles1237353tremble_s
tress55423163tr___ess
triflers113110213triflers
trifles103814823trifle_s
trigness968403trigness
trillers83613493trillers
trimers94615143trim_ers
trimmers12288913trimmers
trimmest12227023trimmest
triolets83410143triolets
triples94616873triple_s
triplets103510263triplets
trollers83211213trollers
trolleys11315693trolleys
trommels12254333trommels
trompes114111623trompe_s
truceless11235393truceless
trueness838693trueness
trumpets12315573trumpets
trustless955953trustless
truthless1244033truthless
tubeless1037023tubeless
tugless837383t_ugless
tummlers12295703tummlers
tuneless837913tuneless
turfless1135533turfless
tuskless1234213tuskless
twigless1293663twigless
wardless12249303wardless
warless104015103_warless
warmness1337063warmness
wartless11279923wartless
wayless13308243_wayless

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.436409841.7
2DLD Change Limit1461622987.34319904.9
3Display Results2982980.1102709.1
 (SQL Overall)1786912987.88922650.7
 
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.