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

174 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
trodden93488(None) 
broaden10289142broaden
hodden113811452_hodden
prodded1257732prodded
prodder1147952prodder
redden83613622_redden
ridden83511722_ridden
rodded93713702_rodded
rodmen939712_rodmen
shodden12265762shodden
sodden84011512_sodden
stridden1044272stridden
trode65322852tro_de_
trudgen9357052trudgen
untrodden1142972untrodden
bidden104010793_bidden
bradded12388713bradded
broadens11267243broadens
broader103412613broader
broider103912973broider
broken124011523bro_ken
brooded113510933brooded
brooder103811623brooder
chidden14255223chidden
codded114515303_codded
codder104416343_codder
coden86128543_co_den
crowded14418793crowded
crowder13389863crowder
crudded1235733crudded
dodder94712913_dodder
erode64520993ero_de_
eroded84313583ero_ded
erodent8313823ero_dent
erodes74819883ero_des
fodder114712113_fodder
frogmen1335893frogmen
fronded12388863fronded
frozen18408443fro_zen
gladden10376313gladden
godded104811803_godded
golden84411153_golden
goodmen1135623goodmen
gridded11387583gridded
gridder10367763gridder
grodier939673grodier
hidden11429743_hidden
hoddens12378803_hoddens
hoddin11369943_hoddin
hoiden103612333_hoiden
holden104113953_holden
hoyden13328933_hoyden
ironmen936453ironmen
kronen10348913kro_nen
loden66621143_lo_den
louden73711793_louden
madden103912523_madden
midden104112853_midden
nodded94012123_nodded
nodder84811943_nodder
odder74515393__odder
olden65114853__olden
oroide7311703oroide_
oroides8311973oroides
outridden1143803outridden
plodded1265563plodded
plodder1146003plodder
podded115012713_podded
prodders1237463prodders
prodding13189343prodding
propmen1338763propmen
prouder10310383prouder
proven114314773pro_ven
radded94716493_radded
redded94019553_redded
reddens9259783_reddens
redder83918143_redder
ridded93615123_ridded
ridder84015143_ridder
roadeo7510323_roadeo
rodding103814533_rodding
rode55844303_ro_de_
rodent7519243_ro_dent
rodeo65921093_ro_deo
rodes614039083_ro_des
rodman949713_rodman
rodsmen1035833_rodsmen
rondel73212643_rondel
rotten64115433_rotten
rouen54920903_ro_uen
roven85521973_ro_ven
rowen84921153_ro_wen
rudder83812803_rudder
sadden83212403_sadden
slidden935153slidden
sodded94113303_sodded
soddens9348413_soddens
strode75215973stro_de_
sudden83310833_sudden
swidden1234233swidden
tedded93810903t_edded
tedder83312163t_edder
thudded1333433thudded
toddies93011993t_oddies
toddle85811033t_oddle
toddled10328823t_oddled
toddler9379043t_oddler
toddles93211533t_oddles
toddy106812423t_odd_y
todies74223553t_odies
token95419313t_o_ken
torten65314353t_orten
trade65026043tr_ade_
traded85717683tr_aded
trader75218763tr_ader
trades75724503tr_ades
treaded95014283treaded
treader84113833treader
treddle936433treddle
treddled1134473treddled
treddles1036263treddles
treen55622753tr__een
trended94011763trended
trident8314193tr_ident
triode75311893triode_
triodes84012503triodes
troaked12438253troaked
troche113112513troche_
trochee122613883trochee
troches123715343troches
trocked144312243trocked
trod57627953tro_d__
troffer13125863troffer
trogon73611753tro_gon
troke94821053tro_ke_
troked114114583tro_ked
trokes104019263tro_kes
trolled84312263trolled
troller73913173troller
trolley10328753trolley
trommel11315363trommel
trompe105611263trompe_
tromped124210293tromped
trompes114111623trompes
trone55131863tro_ne_
trones65629283tro_nes
trooped104010723trooped
trooper94210363trooper
trope75725803tro_pe_
tropes84824353tro_pes
tropin83316753tro_pin
tropine93116653tropine
trothed114010973trothed
trotted83711283trotted
trotter73312253trotter
troupe84812433troupe_
trouped103910983trouped
trouper93811433trouper
troupes94112853troupes
trouser73812473trouser
trove85221923tro_ve_
trover95014663tro_ver
troves94719113tro_ves
trowed104714653tro_wed
trowel94211463tro_wel
trudge8318733trudge_
trudged10298043trudged
trudgens10255153trudgens
trudgeon10253313trudgeon
trudger9338733trudger
trudges9339993trudges
wooden103610303_wooden
woodhen1454723woodhen
woodmen1356053woodmen

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 Filter1786911340270.406440125.6
2DLD Change Limit1340271747.71617370.0
3Display Results1741740.0632761.9
 (SQL Overall)1786911748.18521831.5
 
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.