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

170 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
tramplers1330588(None) 
trampers123210391tramp_ers
trampler12278011trampler_
tramples122610201trample_s
grapplers14274302grapplers
ramblers124010372_ramblers
samplers12299402_samplers
tampers113516742t_amp_ers
trailers82912922tra_ilers
tramless1037502tram_less
trammelers1442512trammelers
tramper113812162tramp_er_
trampier12318242trampier_
trample11299702trample__
trampled13247902trample_d
trappers123711042tra_ppers
travelers12266772travelers
trawlers113310202tra_wlers
tremblers1334482tremblers
amblers115213563__amblers
ampler104313303__ampler_
brabblers12335563brabblers
braillers1135553braillers
brambles14308973bramble_s
brawlers13408643bra_wlers
campers134220293_camp_ers
champers173311623champ_ers
clampers143211893clamp_ers
cradlers11309203cra_dlers
crammers14369353cram_mers
crampier14288903crampier_
crappers144011023cra_ppers
crawlers13309013cra_wlers
crimpers14318933crimp_ers
crimples14308963crimple_s
cripplers15314993cripplers
crumples14348813crumple_s
dampers123915693_damp_ers
drapers105313353dra_p_ers
drawlers12307313dra_wlers
enamelers1144803enamelers
examples1944313example_s
frameless1435533frameless
framers125113823fram__ers
gamblers13369733_gamblers
grabblers14345513grabblers
grappler13336193grappler_
grapples13348123grapple_s
graspers11338403grasp_ers
grumblers14245023grumblers
hampers143616953_hamp_ers
lampers113817333_lamp_ers
pampers133615933_pamp_ers
prattlers11195323prattlers
prompters1537553prompters
rabblers123810853_rabblers
rafflers14317363_rafflers
railers74420663_ra_ilers
rambler113313263_rambler_
rambles113118313_ramble_s
rammers113715043_ram_mers
rampagers1443863_rampagers
rampoles1238893_rampole_s
rapers84327183_ra_p_ers
rapiers95012873_ra_piers
rappers113618443_ra_ppers
raspers94415923_rasp_ers
rattlers83510293_rattlers
ravelers113310863_ravelers
rimples113114223_rimple_s
ripplers12337113_ripplers
rompers113412243_romp_ers
rumblers123610743_rumblers
rumples113313133_rumple_s
rumpless12256543_rumpless
sampler113212013_sampler_
samples112815453_sample_s
scampers143611033scamp_ers
scramblers16183543scramblers
stampers124211603stamp_ers
stampless1334543stampless
staplers103111203sta_plers
straddlers12203823straddlers
stragglers12305253stragglers
stranglers11396823stranglers
strapless1135793stra_pless
strappers1346743stra_ppers
swampers15317473swamp_ers
tacklers143010773t_acklers
tailers73720183t_a_ilers
talers64628143t_a__lers
tamales93216153t_amale_s
tameless10259903t_ameless
tamers84224033t_am__ers
tamper104618513t_amp_er_
tamperers13227313t_amperers
tanglers92911973t_anglers
tapers84025813t_a_p_ers
tappers113416543t_a_ppers
tattlers8369693t_attlers
teamakers1544873teamakers
teamsters1135973teamsters
teaselers9165843teaselers
tempers113513013t_emp_ers
templars1255263t_emplars
temples112610893t_emple_s
templets12226143t_emplets
tempters12257293t_empters
thalers106212263tha__lers
thumpers15365713thump_ers
tipplers12336353t_ipplers
traceless11228643traceless
tracers94917843tra__cers
trachles13311753trachle_s
trackers143512853tra_ckers
trackless15246723trackless
traders84316953tra__ders
traducers1243723traducers
trailer73015393tra_iler_
trailless935963trailless
trainers83114643tra_iners
traipses1036873traipse_s
tramcars1245233tram_cars
trameled11309073tramele_d
tramells10327833tramel_ls
tramels93812493tram__els
trammeler1343223trammeler_
trammels12295413tram_mels
tramped124312433tramp_e_d
trampiest13227893trampiest
trampling1436973trampling
trampoliners1651443trampoliners
tramps105114453tramp___s
transfers1238053transfers
trapes85024463tra_p_e_s
trapper113912803tra_pper_
trashers113013643tra_shers
traveler11328433traveler_
travellers1364663travellers
trawler104011903tra_wler_
trawleys14284383tra_wleys
treadlers1045893treadlers
trembler1235363trembler_
trembles1237353tremble_s
triflers113110213tr_iflers
trillers83613493tr_illers
trimers94615143trim__ers
trimeters1139213trimeters
trimmers12288913trim_mers
triples94616873tr_iple_s
triplets103510263tr_iplets
trippers123210163tr_ippers
trollers83211213tr_ollers
trompes114111623tromp_e_s
troopers10289443troop_ers
troublers1135003troublers
troupers10359443troup_ers
trowelers12105263trowelers
trucklers15295583trucklers
trumpery1533613trump_ery
trumpeters1442633trumpeters
trumpets12315573trump_ets
trundlers10215003trundlers
tumblers123110623t_umblers
tummlers12295703t_ummlers
twaddlers14343613twaddlers
twanglers1363433twanglers
vampers143111623_vamp_ers
wranglers1344273wranglers
wrappers15306933wra_ppers

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 Filter1786911486410.406440125.6
2DLD Change Limit1486411706.59322545.3
3Display Results1701700.0802125.0
 (SQL Overall)1786911707.07925242.4
 
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.