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

148 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
trammels1229541(None) 
tramels93812491tra_mels
trammel11357661trammel_
trommels12254331trommels
crammers14369352crammers
grammes123611322gramme_s
rammers113715042_rammers
stammels12495562stammels
tramel84113712tra_mel_
tramell9398702tra_mell
tramells10327832tramells
tramless1037502tramless
trammed123810712tramme_d
trammeled1453202trammeled
trammeler1343222trammeler
trammelers1442512trammelers
trampers123210392trampers
tramples122610202tramples
travels104711292tra_vels
trimmers12288912trimmers
trommel11315362trommel_
arames84622573ara_me_s
brambles14308973brambles
brimmers14287073brimmers
camels105217083_ca_mels
caramels1238803caramels
clammers143510693clammers
crambes1339963crambe_s
crammed143710123cramme_d
crammer134010963cramme_r
crimmers14298543crimmers
dammers123214273_dammers
damsels10126703_damsels
drammed13378073dramme_d
drummers13316163drummers
enamels9128163ena_mels
framers125113823fra_mers
frames115119863fra_me_s
gammers123214563_gammers
grammars13345943grammars
grammas12499773gramm_as
gramme114210333gramme__
grapnels1134393grapnels
graupels1133103graupels
gravels113611143gra_vels
grommets13234663grommets
grummets13275033grummets
hammals14409223_hammals
hammers144216063_hammers
jammers183710703_jammers
krimmers16315673krimmers
kummels15234793_kummels
mammals10389273_mammals
mammees104411143_mammees
mammers104615693_mammers
mammets103911113_mammets
mammeys13376723_mammeys
pommels13235783_pommels
pummels13236543_pummels
rambles113118313_rambles
ramees84620893_ra_mees
ramets83517393_ra_mets
ramies84630463_ramie_s
ramjets1635163_ramjets
rammed113117303_ramme_d
rammer103519653_ramme_r
ramtils938413_ramtils
rappels11448803_rappels
ratels64518213_ra_tels
ravels94717073_ra_vels
rimmers113812883_rimmers
rummers113513653_rummers
samiels939763_samiels
scammers14339773scammers
shammers153710843shammers
shammes144312833shamme_s
slammers123511223slammers
spammers14378693spammers
stammel11607533stammel_
stammers123611523stammers
strummers1333693strummers
taels56822073t_a__els
tamales93216153t_amales
tamals84116633t_a_mals
tamely113711953t_a_mely
tamers84224033t_a_mers
tames75242013t_a_me_s
tammies113814683t_ammies
tampers113516743t_ampers
tassels74510853t_assels
teasels74311313tea_sels
teazels16406893tea_zels
thermels13607763thermels
thrummers1642413thrummers
tracers94917843tra_cers
traces85329933tra_ce_s
tracheas13410273tracheas
trachles13311753trachles
trackers143512853trackers
traders84316953tra_ders
trades75724503tra_de_s
trailers82912923trailers
trails64622513tra__ils
trainees82712063trainees
trainers83114643trainers
tramcars1245233tramcars
trameled11309073tra_meled
trammeling1544023trammeling
trammelled1542223trammelled
tramming13279343tramming
tramped124312433trampe_d
tramper113812163trampe_r
trample11299703tra_mple
trampled13247903trampled
trampler12278013trampler
tramplers13305883tramplers
tramps105114453tra_m_ps
trams75327673tra_m__s
tramways1643723tramways
trances93919643trance_s
trapes85024463tra_pe_s
trappers123711043trappers
trashers113013643trashers
trashes104119263trashe_s
trasses74819323trasse_s
traumas938593traum_as
travails1146083travails
travel94112983tra_vel_
traves94222743tra_ve_s
trawlers113310203trawlers
trawleys14284383trawleys
trawls94412393tra__wls
trayfuls1443483trayfuls
trembles1237353trembles
tressels8367653tressels
trimers94615143tr_imers
trimmed12348933trimme_d
trimmer113610833trimme_r
trimmest12227023trimmest
trimness1067563trimness
trompes114111623trompe_s
trowels10358363tr_owels
trumpets12315573trumpets
trunnels844513trunnels
tsimmes1133673tsimme_s
tzimmes2033063tzimme_s
wadmels1334303_wadmels
yammers143410323_yammers

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.1561145455.1
2DLD Change Limit1461621487.97018339.0
3Display Results1481480.0602466.7
 (SQL Overall)1786911488.18621828.9
 
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.