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

319 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
iodating103882(None) 
boating103721302bo_ating
borating113414502borating
coating103525312co_ating
dating85326482__dating
doating93816862do_ating
donating10311802donating
ideating10311702ideating
inditing10312112inditing
iodation9310382iodation
iodations1039112iodations
iodinating1246962iodinating
iodising1037562iodising
iodizing1936672iodizing
isolating1039742isolating
locating11311502locating
misdating131010662misdating
moating104218152mo_ating
nidating1039782nidating
notating92513342notating
orating83520322_orating
redating102620172redating
rotating92614552rotating
sedating103014112sedating
solating9315592solating
updating1236592updating
violating1337422violating
abating10413973_abating
ablating11311993ablating
adapting1236643_adapting
adopting1237453adopting
aerating92821003aerating
auditing1039033auditing
aviating12311013aviating
bating95132253__bating
beating104326873_beating
berating113220763berating
bleating113514503bleating
bloating113512813bloating
boasting113512493boasting
boatings113710113bo_atings
boding104320063bod__ing
bodying1438973bod_ying
bogarting1334653bogarting
bolting104416763bo_lting
boosting113311053boosting
booting103821363bo_oting
bromating1439163bromating
cheating144014523cheating
cleating113518133cleating
coacting133412703coacting
coaling103722823co_aling
coaming123818323co_aming
coapting133511613coapting
coasting113615513coasting
coatings113811843co_atings
coaxing173511703co_axing
codding124014693cod_ding
coddling13258473coddling
coding104024793cod__ing
codling114418953cod_ling
coediting1338333coediting
collating12312753collating
comaking1739993comaking
combating16310143combating
compting153013603compting
coopting133411313coopting
costing104323023co_sting
coting94629253co__ting
counting113115263counting
courting112514573courting
coveting141912303coveting
crating103725203_crating
creating113921953creating
curating11314293curating
daring84928683__daring
darting94020663__darting
dauting93814763__dauting
dawing114819823__dawing
dawting123610673__dawting
dazing175516513__dazing
debating123213733debating
delating103119603delating
derating103222283derating
dictating1338883dictating
dilating102714903dilating
disrating11714553disrating
dodging11299063dod_ging
doting84821913__doting
dotting93314483do_tting
doubting1237373doubting
eating75134403__eating
editing9313133_editing
elating83423083_elating
enditing10311073enditing
equating18310113equating
estating92614993estating
etiolating1146973etiolating
fating105328673__fating
filiating1339243filiating
fixating1936183fixating
floating123111883floating
foaling113515843fo_aling
foaming133612993fo_aming
foisting122910503foisting
foliating1339253foliating
footing115017593fo_oting
foraging1358063foraging
foraying1537433foraying
foredating1577123foredating
gating84826953__gating
gelating103015733gelating
gloating102611463gloating
goading103112853go_ading
goaling93515333go_aling
godding113911943god_ding
godling103513403god_ling
gradating1237313gradating
grating93923183_grating
gyrating1337453gyrating
hating104929713__hating
heating114024323_heating
hoaxing18307763ho_axing
hoisting123610903hoisting
homaging1536613homaging
hooting113919873ho_oting
hosting114318383ho_sting
hotting113116513ho_tting
hydrating1746323hydrating
idling8912883i_d_ling
igniting1037363igniting
imaging1138083i_maging
imitating1238763imitating
immolating1545043immolating
impacting1635943impacting
impaling1338253impaling
imparting1437243imparting
impasting1436313impasting
imputing1336853imputing
incaging1288673incaging
incanting1289903incanting
incasing11610603incasing
inciting11312533inciting
indagating1345263indagating
indamin1048043indamin_
indamine1148433indamine
indamins1147603indamins
indenting11911263indenting
indexing1737123indexing
indicating1449693indicating
indicting1339613indicting
indowing13198083indowing
inducing1237873inducing
inducting1338373inducting
induing91910943ind_uing
indurating1249243indurating
inflating13310443inflating
ingoting1039863ingoting
inhaling1239523inhaling
inlacing1158373inlacing
inlaying1247893inlaying
innovating1444613innovating
insolating1149153insolating
instating10812213instating
intonating1148633intonating
inundating1244543inundating
invading1336263invading
inviting1239733inviting
invocating1646333invocating
iodate7313503iodat__e
iodated9310023iodat_ed
iodates8312903iodat_es
iodin64419353iod__in_
iodine74618653iod__ine
iodins74216523iod__ins
ionising9310223ionising
ionizing1839503ionizing
isatin6412213i_satin_
isatine7311763i_satine
isatins7310773i_satins
iterating10314253iterating
jointing16248613jointing
joisting16328503joisting
jolting153410913jo_lting
jotting152912773jo_tting
jousting16309353jousting
legating102313113legating
librating1239053librating
ligating102212283ligating
liquating1946313liquating
loading94114613lo_ading
loafing11319793lo_afing
loaming103613733lo_aming
loaning83614833lo_aning
loathing1247673lo_athing
lodging103110813lod_ging
lofting113311313lo_fting
looting83019643lo_oting
lotting82917753lo_tting
louting83719383lo_uting
luxating1645613luxating
mandating1339773mandating
mating94832913__mating
medaling121912263medaling
mediating13311203mediating
migrating13910533migrating
miseating121215433miseating
mismating141211823mismating
misrating121014853misrating
moaning103714443mo_aning
modeling12311073modeling
modeming1437103modeming
moderating1448803moderating
modulating1446373modulating
molting103517173mo_lting
mooting103019363mo_oting
mordanting1444003mordanting
moulting112710313moulting
mounting112711813mounting
mutating112211753mutating
negating102012833negating
nictating1237573nictating
nitrating10312673nitrating
nodding103811523nod_ding
noddling11237263noddling
nonacting1238783nonacting
noting74120153no__ting
nutating92411953nutating
oaring74225303_o_aring
okaying1534833_okaying
opiating11410093opiating
opting94514403_o_pting
ousting84021353_ousting
outdating11810863outdating
outing74128153_o_uting
oxidating1845053oxidating
ozonating1944323ozonating
pedaling122412133pedaling
phonating1537813phonating
pirating11314513pirating
plating103823073_plating
pleating112916053pleating
podding124113183pod_ding
pointing112813683pointing
pomading1437423pomading
porting103021783po_rting
positing11312303positing
postdating1447163postdating
posting105622243po_sting
potting103720893po_tting
pouting103519943po_uting
prating103424453_prating
predating13514653predating
probating14311183probating
pronating12313763pronating
prorating12314283prorating
pupating1337683pupating
radiating111112123radiating
rating74938703__rating
rebating112418343rebating
redacting13612303redacting
relating92725443relating
remating112322413remating
rioting82716393rio__ting
roaming103215793ro_aming
roaring82916003ro_aring
roasting93012693roasting
rodding103814533rod_ding
rodeoing1037253rodeoing
roosting93411453roosting
rooting83522433ro_oting
rotting82919683ro_tting
rousting93913273rousting
routing83821093ro_uting
sating74735453__sating
seating84130683_seating
sinuating1039683sinuating
situating1038883situating
skating123613843_skating
slating83724653_slating
soaking123116613so_aking
soaping103616223so_aping
soaring83521893so_aring
sodding103712733sod_ding
solacing11310133solacing
solvating1336443solvating
sonatina849073sonatina
sonatine8313323sonatine
sooting82820953so_oting
sopiting11310763sopiting
sorting83221813so_rting
stating83725163_stating
sweating123213023sweating
titrating10310113titrating
toadying1335043toadying
toasting93410573toasting
toddling11187003toddling
toiting83217093to_iting
tooting83019423to_oting
totaling9610303totaling
toting74123793to__ting
totting82816843to_tting
touting84118453to_uting
treating92519613treating
undaring10412753undaring
updarting1334333updarting
uprating11311113uprating
vacating14310343vacating
vibrating1537473vibrating
vitiating1338403vitiating
vomiting1437733vomiting
voting103916033vo__ting
voyaging1632553voyaging
womaning1437643womaning
wonting113214103wo_nting
worsting1267683worsting
wotting112913843wo_tting
yodeling1357673yodeling
yodling123610253yod_ling

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 Filter1786911461620.1731032896.0
2DLD Change Limit1461623197.93618417.6
3Display Results3193190.1402278.6
 (SQL Overall)1786913198.24921662.1
 
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.