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

429 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
iodated931002(None) 
iodate7313501iodate_
iodates8312901iodates
boated94221972bo_ated
borated104116362borated
coated94927042co_ated
dated75530992__dated
doated84118182do_ated
donated93513862donated
ideated9310972ideated
indited93515022indited
iodinated1146942iodinated
iodised9329242iodised
iodized18969162iodized
isolated9410522isolated
lobated102610942lobated
located103114182located
misdated121211122misdated
moated94819002mo_ated
nidated939862nidated
notated82713662notated
orated74221502_orated
redated93120922redated
rotated82715292rotated
sedated93714352sedated
solated83618022solated
togated94410662togated
undated93118462undated
updated11369422updated
violated1237882violated
zonated173310532zonated
abated95918453_abated
ablated102513443ablated
adapted1135843_adapted
adopted1136253adopted
aerated85322373aerated
airdate8311323airdate_
airdates939723airdates
alated75625153_alated
ansated84214003ansated
audited939033audited
aurated83817793aurated
aviated11310263aviated
bated85935533__bated
belated103520013belated
berated104422133berated
bilobated1444973bilobated
bleated104015973bleated
bloated104513433bloated
boasted104113743boasted
boatel84314093bo_atel
boater84622093bo_ater
boded95124963bod__ed
bodied103814583bod_ied
bogarted1235053bogarted
bolted94617803bo_lted
boosted104111983boosted
booted94822733bo_oted
borate85026153borate_
borates94823013borates
bromated1339173bromated
caudated1238063caudated
cerated103922473cerated
cheated134416343cheated
ciliated11510953ciliated
citrated112712253citrated
cleated103417843cleated
coacted123611613coacted
coadapted1543163coadapted
coaled95022713co_aled
coapted123911503coapted
coasted104015953coasted
coatee84327223co_atee
coater84329573co_ater
coaxed165612513co_axed
codded114515303cod_ded
coddled123410573coddled
coded95433183cod__ed
coedited1237833coedited
collated113615063collated
comate104124843comate_
comates114123643comates
combated1539823combated
compted143813523compted
coopted123710763coopted
cordate10315223cordate_
costed95623113co_sted
coted85033853co__ted
counted103815803counted
courted103514923courted
coveted133011523coveted
crated94827773_crated
created104323453created
curated104717583curated
dared75935013__dared
darted84620923__darted
date56443323__date_
dater65332313__dater
dates65639153__dates
dauted84114933__dauted
dawed106222813__dawed
dawted11489683__dawted
dazed165919363__dazed
debated113916083debated
delated93722873delated
derated93623503derated
dictated1239203dictated
dilated93115823dilated
disrated10915573disrated
dodged107514693dod_ged
doited85016633do_ited
donate73619503donate_
donates83217223donates
doted75227073__doted
dotted84717523do_tted
doubted11307483doubted
edited83913673_edited
elated74725823_elated
endited93512913endited
equated171910403equated
estated83715573estated
etiolated1047073etiolated
fated95632133__fated
filiated12610083filiated
fixated1835533fixated
floated113312703floated
foaled104515963fo_aled
foamed126014403fo_amed
foisted113210603foisted
folate93320393folate_
folates103218453folates
foliated1249913foliated
footed104418623fo_oted
foraged124812283foraged
forayed14368593forayed
foredated1447683foredated
foveated1536293foveated
gated75329773__gated
gelated93615643gelated
gloated93511533gloated
globated1265753globated
goaded94913713go_aded
goaled85014363go_aled
goatee73219533go_atee
goateed9307063go_ateed
godded104811803god_ded
gowaned1235763gowaned
gradated1157433gradated
grated84523923_grated
gyrated12428413gyrated
hated95734023__hated
heated104525593_heated
hoaxed17378873ho_axed
hodad10311353hoda__d
hoisted113411293hoisted
homaged1497413homaged
hooted104422663ho_oted
hosted105020343ho_sted
hotted104319943ho_tted
hydatid1546523hydatid
hydrated16216953hydrated
ideate7313683ideate_
ideates8313733ideates
idled74915213i_d_led
idolater936863idolater
ignited9137623ignited
imaged1097763i_maged
imitated1138263imitated
immolated1444873immolated
impacted15286353impacted
impaled12288513impaled
imparted13248063imparted
impasted13297553impasted
imputed1236533imputed
incaged114010443incaged
incanted11259543incanted
incased103612393incased
incited103314623incited
indagated1245573indagated
indebted12246873indebted
indeed83913563ind_eed
indented101811733indented
indexed16347363indexed
indicated13310953indicated
indicted1249203indicted
indite73520323indite_
inditer83514233inditer
indites83618983indites
indowed1237443indowed
induced11298933induced
inducted1237273inducted
indued83411653ind_ued
indurated1139013indurated
inedited10278993inedited
inflated12410863inflated
ingate73018243ingate_
ingates82716913ingates
ingoted939183ingoted
inhaled1169333inhaled
inlaced10239873inlaced
inmate82917363inmate_
inmates92715783inmates
innate63917313innate_
innovated1344573innovated
insolated1039713insolated
instated91613343instated
intonated1048303intonated
inundated1144753inundated
invaded12127043invaded
invited113612463invited
invocated1546203invocated
iodating1038823iodating
iodation9310383iodation
iodid74315533iod__id
iodide84812933iodide_
iodides93811613iodides
iodinate949343iodinate_
iodinates1048203iodinates
iodine74618653iodine_
iodines83616633iodines
iodise74214943iodise_
iodises83413633iodises
iodize164112593iodize_
iodizer17408663iodizer
iodizes173911723iodizes
iolite63221983iolite_
iolites73819483iolites
ionised82911493ionised
ionized172611293ionized
irate55627983i_rate_
irater65218353i_rater
isleted837523isleted
isolate7313923isolate_
isolates8613513isolates
iterated91213823iterated
jointed15378503jointed
joisted15379173joisted
jolted143510633jo_lted
jotted143615173jo_tted
jousted15339143jousted
lanated8313203lanated
lated65240673__lated
legated92513983legated
librated113110313librated
ligated92414143ligated
lineated9711063lineated
liquated1835493liquated
loaded84616873lo_aded
loafed104011153lo_afed
loamed94414613lo_amed
loaned73816293lo_aned
loathed11419443lo_athed
lobate82915243lobate_
locate83919843locate_
locater93113603locater
locates93218813locates
lodged913815713lod_ged
lofted103811893lo_fted
looted74421113lo_oted
lotted74222403lo_tted
louted74920693lo_uted
lunated8310823lunated
luxated1535713luxated
lyrated11388473lyrated
mandated12310293mandated
mated85537783__mated
meated94222403_meated
medaled113411613medaled
mediated123011873mediated
migrated121110513migrated
misdate101413963misdate_
misdates111113633misdates
mismated131111333mismated
misrated111315383misrated
moaned94514173mo_aned
modeled1139463modeled
modemed1336723modemed
moderated1388143moderated
modulated1336713modulated
molted94217473mo_lted
mooted94120373mo_oted
mordanted1344413mordanted
moulted103310313moulted
mounted103611533mounted
mutated102712253mutated
negated93413233negated
nictated1137793nictated
nidate7313783nidate_
nidates8311893nidates
niobate937703niobate_
niobates1037283niobates
nitrated92213153nitrated
nodded94012123nod_ded
noddled10358563noddled
nonrated9310843nonrated
notate63217863notate_
notates72817483notates
noted65123843no__ted
nutated83113423nutated
oared65030653_o_ared
oaten55222403_o_aten
oater55433733_o_ater
odored8399223_odored
okayed1434253_okayed
opiated1039483opiated
opted84914273_o_pted
orate55133303_orate_
orates64328613_orates
ousted73720583_ousted
outdated1012513193outdated
outed65429063_o_uted
ovate84214393_ovate_
oxidated1745033oxidated
ozonated1864593ozonated
pated85237843__pated
pedaled113711893pedaled
pedate93117763pedate_
phonated1447893phonated
picrated132110113picrated
pileated112711133pileated
pinnated11338553pinnated
pirated102515613pirated
plated95225773_plated
pleated103816633pleated
podded115012713pod_ded
podite93315353podite_
podites103014733podites
pointed103813983pointed
pomaded13377863pomaded
ported94223243po_rted
posited10511493posited
postdated1346883postdated
posted93722493po_sted
potted94624013po_tted
pouted94021393po_uted
prated94924923_prated
predated12513273predated
probated13410863probated
pronated11414053pronated
prorated11513713prorated
pupated12319353pupated
radiated102512593radiated
rated65441383__rated
rebated103619703rebated
redacted12410243redacted
redate74124683redate_
redates83423873redates
related83327573related
remated103522473remated
rioted73416373rio__ted
roadbed1134793roadbed
roamed95215093ro_amed
roared75015393ro_ared
roasted83912663roasted
rodded93713703rod_ded
rodeoed937883rodeoed
roosted83211883roosted
rooted75424003ro_oted
rotate63320343rotate_
rotates72819773rotates
rotted74524433ro_tted
rousted84013323rousted
routed75624333ro_uted
sated66238533__sated
seated75131063_seated
sedate73019813sedate_
sedater83713633sedater
sedates83418043sedates
sinuated938413sinuated
situated938033situated
skated114414883_skated
slated75028313_slated
soaked114717593so_aked
soaped95817973so_aped
soared74324293so_ared
sodded94113303sod_ded
sofabed1334333sofabed
solaced102911063solaced
solate64526073solate_
solates73523853solates
solvated12237443solvated
sooted73922593so_oted
sopited104211063sopited
sorted74523713so_rted
sotted74121403so_tted
stated75427833_stated
sweated113411543sweated
teated74924023_teated
titrated92611683titrated
toadied9248013toadied
toasted84011923toasted
toddled10328823toddled
togaed84711343toga_ed
togate74515683togate_
toited74016753to_ited
tooted74620123to_oted
totaled839693totaled
toted64929483to__ted
totted74319953to_tted
touted74419743to_uted
treated83618703treated
unbated103317733unbated
ungated92717213ungated
unmated103317023unmated
unrated82621553unrated
unsated83419933unsated
updarted1244313updarted
update93810293update_
updater10347253updater
updates10329793updates
uprated103213323uprated
vacated1349353vacated
vibrated14228393vibrated
violate10311553violate_
violater1137253violater
violates11311193violates
vitiated12289223vitiated
voluted11297943voluted
vomited1337253vomited
voted93919143vo__ted
voyaged1533513voyaged
woaded115211603wo_aded
womaned1337213womaned
wonted103213283wo_nted
worsted1138013worsted
wotted104115713wo_tted
yodeled1236863yodeled
yodled11389653yod_led
zonate154114923zonate_

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 Filter1786911340270.393454684.5
2DLD Change Limit1340274297.23318529.9
3Display Results4294290.1562750.0
 (SQL Overall)1786914297.78222962.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.