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

187 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
trade6502604(None) 
grade75126091grade
irade65618151irade
tirade7311691tirade
trace75829611trace
trad55630911trad_
traded85717681traded
trader75218761trader
trades75724501trades
trave85223031trave
trode65322851trode
tsade64311121tsade
abrade9313052abrade
arame75026622arame
arcade91013642arcade
bade75140882_bade
barde85330772barde
blade85923332blade
brace95629272brace
brad75234342brad_
brads85528292brads
brae65639112bra_e
brake116025342brake
brave104925502brave
braze165423452braze
brede85520502brede
bride86425532bride
cade76443912_cade
clade85821012clade
cradle93313162cradle
crake114823522crake
crane75331602crane
crape96128442crape
crate76537402crate
crave105626312crave
craze165221462craze
crude86018572crude
drake104918302drake
drape85319632drape
drave95219272drave
erase54925492erase
erode64520992erode
evade938182evade
fade85736342_fade
frae75330472fra_e
frame105821802frame
glade75121962glade
grace85124542grace
grad66829862grad_
graded94919552graded
grader84919692grader
grades84926312grades
grads75625752grads
grape84824662grape
grate64932882grate
grave94624872grave
graze155820052graze
gride75223582gride
hade85440192_hade
irades74517392irades
irate55627982irate
jade125325442_jade
lade56345982_lade
made75440242_made
orad56031692orad_
orate55133302orate
parade94720642parade
prase76128752prase
prate75135982prate
pride84724732pride
prude84615972prude
race66746262_race
rad47662002_rad_
rads56046602_rads
rage55742352_rage
rake84841572_rake
rale45050562_rale
rape65041632_rape
rare45348432_rare
rase46149982_rase
rate45458762_rate
rave75542092_rave
raze135235432_raze
rede55037672_rede
ride55945132_ride
rode55844302_rode
rude55632782_rude
sade55544472_sade
shade95125582shade
spade84423322spade
stade64825302stade
strafe95215982strafe
strake104017392strake
stride75420962stride
strode75215972strode
tace65342512t_ace
tad47959822t_ad_
tads57143942t_ads
tae38267052t_a_e
take84739262t_ake
tale46154162t_ale
tame66343662t_ame
tape64538142t_ape
tardo65321102tardo
tardy94720462tardy
tare45957622t_are
tared69340052tared
targe65227092targe
tarre55825632tarre
tate44748602t_ate
tease55428712tease
thae76825562tha_e
thane86122532thane
thrave126010272thrave
tide55237382t_ide
tilde65017342tilde
tirades8311722tirades
toad55830182toad_
toads65621072toads
toady96814342toady
torsade837592torsade
traced94821582traced
tracer84820232tracer
traces85329932traces
track114823012track
tract75635712tract
traders84316952traders
traduce1036352traduce
tragi64717172tragi
traik95418202traik
trail55126772trail
train56529112train
trait56940842trait
tram67034552tra_m
tramel84113712tramel
tramp96319772tramp
trams75327672trams
trance84718762trance
trank96222422trank
tranq145416892tranq
trans54933042trans
trap67532802tra_p
trapes85024462trapes
traps75727482traps
trapt76433392trapt
trash86119762trash
trass56226472trass
travel94112982travel
traves94222742traves
trawl84915872trawl
tray77632592tra_y
trays85623432trays
tread64821702tread_
treaded95014282treaded
treader84113832treader
treadle8310102treadle
treads74817922treads
tree47745812tr_ee
treed65626732treed
triad65217722triad_
triads74513532triads
triage72812892triage
tribade1037292tribade
tribe74420272tribe
trice75127492trice
tried65026912tried
trike95320162trike
trine54734602trine
triode75311892triode
tripe75425382tripe
trite54730032trite
trod57627952trod_
troke94821052troke
trone55131862trone
trope75725802trope
trove85221922trove
truce75118692truce
trudge8318732trudge
true46725852tr_ue
trued65117692trued
tsades74310992tsades
tsadi6379912tsadi
twae74719572twa_e
urare56322552urare
urase54624692urase
urate55432162urate
wade85237062_wade

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.330541487.9
2DLD Change Limit538001871.54634799.5
3Display Results1871870.0603116.7
 (SQL Overall)1786911871.93692299.1
 
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.