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

353 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
updated1136942(None) 
undated93118461undated
updarted1244311updarted
update93810291update_
updater10347251updater
updates10329791updates
uprated103213321uprated
dated75530992__dated
iodated9310022iodated
nidated939862nidated
opiated1039482opiated
outdated1012513192outdated
pated85237842_p_ated
plated95225772_plated
prated94924922_prated
pupated12319352pupated
redated93120922redated
sedated93714342sedated
unbated103317732unbated
ungated92717212ungated
unmated103317022unmated
unrated82621552unrated
unsated83419932unsated
updaters11255172updaters
updived1434092updived
updried11226472updried
upgazed2033422upgazed
uprate83916542uprate_
uprates93814862uprates
upwafted1742192upwafted
abated95918453_abated
ablated102513443ablated
adapted1135833_adapted
aerated85322373aerated
alated75625143_alated
ansated84214003ansated
audited939033audited
aurated83817793aurated
aviated11310263aviated
bated85935533__bated
belated103520013belated
berated104422133berated
bleated104015973bleated
bloated104513433bloated
boated94221973_boated
borated104116363borated
caudated1238063caudated
cerated103922473cerated
cheated134416343cheated
cleated103417843cleated
coated94927033_coated
crated94827773_crated
created104323443created
cuneated11310103cuneated
curated104717583curated
cuspated1335913cuspated
dared75935013__dared
darted84620923__darted
date56443323__date_
dater65332313__dater
dates65639153__dates
dauted84114933__dauted
dawed106222813__dawed
dawted11489683__dawted
dazed165919363__dazed
debated113916083debated
delated93722873delated
derated93623503derated
dilated93115823dilated
doated84118183_doated
donated93513863donated
doted75227073__doted
edited83913673_edited
elated74725823_elated
endited93512913endited
epilated11310753epilated
equated171910403equated
estated83715573estated
expiated18168523expiated
fated95632133__fated
fixated1835533fixated
floated113312703floated
furcated1437593furcated
gated75329773__gated
gelated93615633gelated
gloated93511533gloated
gradated1157433gradated
grated84523923_grated
guttated10266873guttated
gyrated12428413gyrated
hated95734023__hated
heated104525593_heated
hydatid1546513hydatid
hydrated16216953hydrated
ideated9310973ideated
indited93515023indited
inundated1144753inundated
iodate7313503iodate_
iodates8312893iodates
lanated8313203lanated
lapidated1345673lapidated
lated65240673__lated
legated92513983legated
ligated92414133ligated
lobated102610943lobated
located103114183located
lunated8310823lunated
luxated1535713luxated
lyrated11388473lyrated
mandated12310283mandated
mated85537783__mated
meated94222403_meated
medaled113411603medaled
mediated123011873mediated
misdated121211113misdated
moated94819003_moated
muriated1139793muriated
mutated102712253mutated
negated93413233negated
nidate7313783nidate_
nidates8311883nidates
notated82713663notated
nutated83113423nutated
operated11512223operated
opiate8513463opiate_
opiates9312143opiates
opted84914273op__ted
orated74221503_orated
outdared102711513outdared
outdate83016423outdate_
outdates93114743outdates
outrated92219313outrated
oxidated1745033oxidated
paced106931683_p_aced
padded114113503_padded
paged95926783_p_aged
paled85538723_p_aled
paned85437183_p_aned
panted95024823_panted
pared86946763_p_ared
parted94228683_parted
pasted94426903_pasted
pate65350463_p_ate_
paten74827343_p_aten
pater74740723_p_ater
pates76047893_p_ates
patted94724683_patted
paved115525263_p_aved
pawed115725613_p_awed
payed115925933_p_ayed
peaced115818913_peaced
peaked136117403_peaked
pealed95322803_pealed
pedaled113711873pedaled
pedate93117763pedate_
pelted94617753_pelted
petted94121523_petted
phased124011973_phased
pirated102515613pirated
pitted94319593_pitted
placed114318003_placed
plaited103713893_plaited
planed94420913_planed
planted103516123_planted
plate74635113_plate_
platen84518203_platen
plater84427693_plater
plates85432243_plates
platted103614263_platted
played124815033_played
pleated103816633pleated
ported94223243_ported
posted93722493_posted
potted94624013_potted
pouted94021393_pouted
prate75135983_prate_
prater84825353_prater
prates84633163_prates
prayed124815433_prayed
predated12513273predated
puddled123011193puddled
pulsated1136853pulsated
punted94618713_punted
pupate104213123pupate_
pupates113311433pupates
putted94220253_putted
quadrated2055913quadrated
radiated102512593radiated
rated65441383__rated
rebated103619693rebated
redacted12410243redacted
redate74124683redate_
redates83423863redates
related83327573related
remated103522473remated
repeated113117443repeated
replated112817513replated
rotated82715293rotated
ruinated939523ruinated
sated66238533__sated
seated75131053_seated
sedate73019803sedate_
sedater83713623sedater
sedates83418033sedates
skated114414873_skated
slated75028313_slated
solated83618023solated
spaced114517253sp_aced
spaded103816753sp_aded
spaed85522273sp_a_ed
spared95427483sp_ared
spate74731583sp_ate_
spates85028173sp_ates
spathed134013183sp_athed
spatted104014143spatted
spayed124213613sp_ayed
speaned103411523speaned
speared104314423speared
spicated13309903spicated
spirted103913073spirted
spited94820443sp_ited
spitted103912703spitted
splatted11356743splatted
splayed13357813splayed
sported104015433sported
spotted103713133spotted
spouted103412263spouted
sprayed13398903sprayed
spurted103111973spurted
stated75427833_stated
sublated11311493sublated
sulcated11310373sulcated
sulfated1238833sulfated
sulphated1544723sulphated
summated13298833summated
supinated1237873supinated
sweated113411543sweated
teated74924023_teated
togated94410663togated
treated83618703treated
ullaged937033ullaged
ululated947663ululated
umlauted1132823umlauted
unabated11310133unabated
unacted10312733unacted
unadapted1344653unadapted
unadded10238523unadded
unaged83916423u_naged
unawed103914903u_nawed
unaxed144113093u_naxed
unbaked143312893unbaked
unbaled103315963unbaled
unbased103513483unbased
unbasted112510073unbasted
unbathed1437223unbathed
uncaged113314123uncaged
uncaked143514353uncaked
uncarted11312053uncarted
uncased104216953uncased
uncoated11314963uncoated
uncrated11416313uncrated
undamped1445333undamped
undaunted1145453undaunted
undebated1338093undebated
undented102313953undented
undotted1048523undotted
undraped1239393undraped
undried92314613undried
undulated11310083undulated
undyed1138143und_yed
uneaten7412543uneaten
unedited10249833unedited
unfaded123111733unfaded
unfaked153211173unfaked
unfazed20299053unfazed
unhatted1238183unhatted
unheated121514553unheated
united74421543u_nited
unjaded16279143unjaded
unlaced102913733unlaced
unladed92614373unladed
unmatted1138293unmatted
unnamed102410273unnamed
unnoted8311363unnoted
unpadded1345183unpadded
unpaged113311043unpaged
unparted11310823unparted
unpaved133410053unpaved
unpitted1148623unpitted
unplaced1338613unplaced
unplaited1236883unplaited
unplanted1236853unplanted
unplayed1437263unplayed
unposted1159433unposted
unpotted11108393unpotted
unraked122914013unraked
unrazed172511453unrazed
unsalted9510923unsalted
unsaved113312193unsaved
unsawed112911503unsawed
unseated91317683unseated
unstated91615813unstated
untamed102913223untamed
untasted92011573untasted
untaxed152710583untaxed
unwanted12249603unwanted
unwasted12259783unwasted
unwaxed18308393unwaxed
upases84112903up_ases
updart9310743upda_rt
updarts1034203updarts
updating1236593updating
updive1234903updive_
updives1334713updives
updove1234483updove_
updries10209083updries
upended11267323upended
upgather14152753upgather
upgaze1833543upgaze_
upgazes1933573upgazes
upgraded13215683upgraded
upheaped1633643upheaped
upheaved1733763upheaved
upland938863upla_nd
upleaped1334333upleaped
uplifted1454423uplifted
uploaded1234533uploaded
upped103715163up__ped
uppiled12216593uppiled
upraised11167413upraised
upreared1137073upreared
uprooted1186393uprooted
upscaled13144873upscaled
upsized19246243upsized
upsoared11154353upsoared
upstaged12135243upstaged
upstand1045343upstand
upstared11156573upstared
upstarted1244213upstarted
upstate91610493upstate_
upstater10156663upstater
upstates10189643upstates
upstep1035503up_step
uptake1236963uptake_
uptakes1336593uptakes
uptalked1533053uptalked
uptilted1174673uptilted
upward12147163upwa_rd
urate55432163u_rate_
urates65027763u_rates
urinated9311613urinated
vacated1349353vacated
zonated173310533zonated

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.1561145455.1
2DLD Change Limit1340273537.95316852.4
3Display Results3533530.1262801.6
 (SQL Overall)1786913538.23521699.0
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.