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 “trode” with Change Limit: [1] [2]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

159 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
trode6532285(None) 
erode64520991erode
rode55844311_rode
strode75215971strode
trade65026041trade
triode75311891triode
trod57627951trod_
troke94821051troke
trone55131861trone
trope75725801trope
trove85221921trove
abode85518812abode
anode65021042anode
arose55832082arose
bode75838762_bode
brede85520502brede
bride86425542bride
broke116019782broke
brome94421972brome
brose75227032brose
code77347742_code
crone75231332crone
crore74922872crore
croze164719452croze
crude86018572crude
diode74716122diode
drone65324982drone
drove95518062drove
epode85114092epode
eroded84313592eroded
erodes74819882erodes
erose55727282erose
froe75329992fro_e
frore86218802frore
froze174515652froze
geode7412592geode
grade75126092grade
gride75223592gride
grody103412062grody
grope84821612grope
grove95219332grove
horde94623052horde
irade65618152irade
irone55126362irone
krone94018732krone
lode56240122_lode
mode75840312_mode
node513036892_node
ode47446592__ode
oroide7311702oroide
outrode82313422outrode
pride84724742pride
probe94320812probe
prod76129502prod_
prods85523552prods
prole74527792prole
prone75332622prone
prose75835122prose
prove104823192prove
prude84615972prude
rede55037682_rede
ride55945142_ride
robe65335642_robe
rod47953902_rod_
rodeo65921092_rodeo
rodes614039082_rodes
rods56442072_rods
roe36861082_ro_e
role45851822_role
rope65542912_rope
rose46148902_rose
rote46249022_rote
roue45941742_roue
rove75136982_rove
rude55632792_rude
sarode75317512sarode
spode84617702spode
stride75420962stride
strobe84513812strobe
stroke105116172stroke
strove95014792strove
tetrode839342tetrode
thole85620842thole
those85218142those
throe89321422thro_e
throne98517602throne
throve128012392throve
tide55237392t_ide
tilde65017352tilde
tirade7311692tirade
tod49457082t_od_
tods56141852t_ods
tody86327222t_ody
toe310166852t_o_e
toed56137042t_oed
toke86738492t_oke
tole46052902t_ole
tome67543192t_ome
tone46953742t_one
tope65946382t_ope
tore47359322t_ore
torose64317692torose
torse55833332torse
torte55431702torte
tote46643672t_ote
trace75829612trace
trad55630912trad_
traded85717682traded
trader75218762trader
trades75724502trades
trave85223032trave
tree47745812tr_ee
treed65626732treed
tribe74420272tribe
trice75127492trice
tried65026912tried
trike95320162trike
trine54734602trine
triodes84012502triodes
triose64715382triose
tripe75425382tripe
trite54730032trite
troak95213572troak
troche113112512troche
trock114817602trock
trodden934882trodden
trog57628212tro_g
trogs67022602trogs
trois57226092trois
troked114114582troked
trokes104019262trokes
troll54416532troll
tromp95815802tromp
trompe105611262trompe
trona54118952trona
trones65629282trones
troop76417532troop
trooz145016152trooz
trop66833302tro_p
tropes84824352tropes
trot46351312tro_t
troth85622202troth
trots56629942trots
troupe84812432troupe
trout57332572trout
trover95014662trover
troves94719112troves
trow78031422tro_w
trowed104714652trowed
trowel94211462trowel
trows88826182trows
troy77429682tro_y
troys86418612troys
truce75118692truce
trudge8318732trudge
true46725852tr_ue
trued65117692trued
tsade64311122tsade
wrote84717482wrote

Search took 2 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 Filter178691538000.326548131.9
2DLD Change Limit538001591.57634137.1
3Display Results1591590.0503180.0
 (SQL Overall)1786911591.95291542.5
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.