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

393 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
notating9251334(None) 
nutating92411951nutating
rotating92614551rotating
annotating1146232annotating
boating103721302bo_ating
borating113414502borating
coating103525312co_ating
doating93816862do_ating
donating10311802donating
dotting93314482dot_ting
estating92614992estating
hotting113116522hot_ting
instating10812212instating
iodating1038822iodating
jotting152912772jot_ting
knotting13236572knot_ting
locating11311502locating
lotting82917752lot_ting
moating104218152mo_ating
mutating112211752mutating
negating102012832negating
netting84018762net_ting
nictating1237572nictating
nidating1039782nidating
nitrating10312672nitrating
nonacting1238782nonacting
notation81414602notation
notations91512972notations
notching14288582notching
nothing113511902not_hing
noticing1139452noticing
noting74120152no__ting
nutting83316232nut_ting
orating83520322_orating
potting103720892pot_ting
rotting82919682rot_ting
solating9315592solating
stating83725162_stating
totaling9610302totaling
totting82816842tot_ting
unstating10711212unstating
wotting112913842wot_ting
abating10413973_abating
ablating11312003ablating
actuating1239233actuating
aerating92821003aerating
agitating1138863agitating
animating12312513animating
anointing1038623anointing
astatine8313533astatine
aviating12311033aviating
bating95132253__bating
batting104422273bat_ting
beating104326873_beating
berating113220763berating
betaking153010153betaking
betting103921403bet_ting
bitting103717293bit_ting
blatting114111653blatting
bleating113514503bleating
bloating113512813bloating
blotting113910433blot_ting
boasting113512503boasting
boatings113710113bo_atings
bogarting1334653bogarting
bolting104416763bo_lting
boosting113311053boosting
booting103821363bo_oting
botching16359703botching
bottling11279143bottling
bromating1439183bromating
butting103519283but_ting
catting103922643cat_ting
chatting142810143chatting
cheating144014523cheating
cleating113518143cleating
clotting113110643clot_ting
coacting133412703coacting
coaling103722823co_aling
coaming123818323co_aming
coapting133511613coapting
coasting113615513coasting
coatings113811843co_atings
coaxing173511703co_axing
cogitating1447213cogitating
collating12312783collating
comaking1739993comaking
combating16310163combating
compting153013603compting
contacting15610073contacting
coopting133411313coopting
corotating1349323corotating
costing104323023co_sting
coting94629253co__ting
counting113115273counting
courting112514573courting
coveting141912313coveting
crating103725203_crating
creating113921953creating
curating11314293curating
cutting103817493cut_ting
dating85326483__dating
debating123213733debating
delating103119603delating
derating103222283derating
dictating1338883dictating
dilating102714913dilating
dotation91412733dotation
dotations101411633dotations
doting84821913do__ting
doubting1237373doubting
dratting10389663dratting
eating75134403__eating
elating83423083_elating
equating18310113equating
fating105328673__fating
fatting113818703fat_ting
fetting113517873fet_ting
fitting113516563fit_ting
fixating1936183fixating
flatting123511253flatting
floating123111883floating
foaling113515843fo_aling
foaming133612993fo_aming
foisting122910503foisting
foliating1339253foliating
footing115017593fo_oting
foraging1358063foraging
foraying1537433foraying
gating84826953__gating
gelating103015733gelating
gestating11229983gestating
getting93316563get_ting
gitting93215703git_ting
gloating102611463gloating
goading103112853go_ading
goaling93515333go_aling
grating93923183_grating
gutting93415923gut_ting
gyrating1337453gyrating
hating104929713__hating
hatting113920233hat_ting
heating114024323_heating
hitting113017273hit_ting
hoaxing18307763ho_axing
hoisting123610903hoisting
homaging1536613homaging
hooting113919883ho_oting
hosting114318383ho_sting
hotching17309313hotching
hutting113016033hut_ting
ideating10311703ideating
imitating1238763imitating
inflating13310443inflating
initiating1149623initiating
innovating1444613innovating
insolating1149153insolating
intonating1148633intonating
intorting10311413intorting
invocating1646333invocating
isolating1039743isolating
jetting153815343jet_ting
jointing16248613jointing
joisting16328503joisting
jolting153410913jo_lting
jottings16275193jot_tings
jousting16309353jousting
jutting153313713jut_ting
kitting123214443kit_ting
knitting13257023knit_ting
knottings14243073knot_tings
knouting13226793kno_uting
kotowing1634013kotowing
lactating1239193lactating
legating102313113legating
letting83218533let_ting
ligating102212283ligating
loading94114613lo_ading
loafing11319793lo_afing
loaming103613733lo_aming
loaning83614833lo_aning
loathing1247673loathing
lofting113311313lo_fting
looting83019643lo_oting
louting83719383lo_uting
luxating1645613luxating
mating94832913__mating
matting103620143mat_ting
metaling111613723metaling
moaning103714443mo_aning
molting103517173mo_lting
montaging1346543montaging
mooting103019363mo_oting
mortaring1237943mortaring
motivating1646803motivating
motiving1437163motiving
motoring11410953motoring
mottling11197753mottling
moulting112710313moulting
mounting112711813mounting
naming93917893n__aming
narrating10310353narrating
natation81513933natation
natations91412493natations
nearing83020333n_earing
negotiating1344243negotiating
nesting84320443n_esting
nettings9288103net_tings
nettling957213nettling
nobbling13228273nobbling
nocking143615113no_cking
nodding103811523no_dding
noddling11237263noddling
nogging103612723no_gging
noising83615173no_ising
nominating1349503nominating
nonbeing1137053nonbeing
nonbiting1247823nonbiting
noncaking1646683noncaking
noncling11310763noncling
nonfading1445873nonfading
nonpaying1545713nonpaying
nonrotating1246303nonrotating
nonusing939233nonusing
nonvoting1346903nonvoting
noodging11185693noodging
noodling10209443noodling
nooning83014853no_oning
noosing83315053no_osing
northing12199063northing
noshing114612773no_shing
nosing73419843no__sing
notarial8410753notarial
notaries8314933notaries
notarize1749293notarize
notarizing2067613notarizing
notate63217863notat__e
notated82713663notat_ed
notates72817483notat_es
notational1048123notational
nothings12266683not_hings
notifying1645623notifying
novation111710013novation
novations12139003novations
nutation81513103nutation
nutations91411763nutations
nuttings9276783nut_tings
nystatin1145093nystatin_
nystatins1244753nystatins
oaring74225303_o_aring
okaying1534833_okaying
opiating11410093opiating
opting94514403_o_pting
ousting84021353_ousting
outacting1239213outacting
outdating11810863outdating
outeating10814493outeating
outing74128153_o_uting
outrating10916403outrating
ozonating1944323ozonating
patting103722343pat_ting
petting103720953pet_ting
phonating1537813phonating
pirating11314513pirating
pitting103618873pit_ting
plating103823073_plating
platting114813033platting
pleating112916053pleating
plotting113011013plot_ting
pointing112813683pointing
pomading1437423pomading
portaging1346843portaging
porting103021783po_rting
positing11312303positing
postdating1447163postdating
posting105622243po_sting
postmating1548603postmating
potation101716783potation
potations111615073potations
pouting103519943po_uting
prating103424453_prating
probating14311193probating
pronating12313763pronating
prorating12314283prorating
pupating1337683pupating
putting103218573put_ting
rating74938703__rating
ratting83822363rat_ting
rebating112418343rebating
redating102620173redating
relating92725443relating
remating112322423remating
renovating1447423renovating
restating102319413restating
retaking133114283retaking
retaping113012553retaping
retasting102513413retasting
retaxing162311333retaxing
retting83425883ret_ting
roaming103215793ro_aming
roaring82916003ro_aring
roasting93012703roasting
roosting93411463roosting
rooting83522433ro_oting
rotation81615453rotation
rotations91613843rotations
rotative11310343rotative
rousting93913273rousting
routing83821093ro_uting
rutting82718043rut_ting
sanitating1149653sanitating
satiating10311813satiating
sating74735453__sating
scatting113311813scatting
seating84130683_seating
sedating103014113sedating
setting83621393set_ting
shotting123012383shot_ting
sitting83519633sit_ting
situating1038883situating
skating123613853_skating
slating83724653_slating
slatting94014233slatting
slotting92612613slot_ting
snooting92813203sno_oting
snorting92613373sno_rting
snouting92511923sno_uting
soaking123116613so_aking
soaping103616223so_aping
soaring83521893so_aring
solacing11310133solacing
solvating1336443solvating
sonatina849073sonatina
sonatine8313323sonatine
sooting82820963so_oting
sopiting11310763sopiting
sorting83221813so_rting
spatting113111763spatting
spotting112812093spot_ting
staging93818373_staging
staking123919803_staking
staling83925423_staling
staning83922243_staning
staring84527053_staring
starting93116173_starting
statin63921473_statin_
statins73719773_statins
staving113915703_staving
staying114017323_staying
stotting92811163stotting
swatting12309593swatting
sweating123213023sweating
swotting12268483swot_ting
taking114725953__taking
taming94023433__taming
taping94222393__taping
taring73932283__taring
tarting84222653__tarting
tasting84624213__tasting
tatting84019523__tatting
tauting83316383__tauting
tawing104521553__tawing
taxing143816713__taxing
titrating10310113titrating
toasting93410583toasting
toiting83217093to_iting
tooting83019423to_oting
totalling1036523totalling
toting74123793__toting
touting84118453to_uting
treating92519613treating
trotting92510913trot_ting
tutting83515913tut_ting
unabating1246753unabating
uncoating12611923uncoating
uncrating12813183uncrating
unhatting1335873unhatting
unseating10713203unseating
updating1236593updating
uprating11311113uprating
vacating14310363vacating
vatting113614853vat_ting
vetting114216563vet_ting
violating1337443violating
vitiating1338413vitiating
vomiting1437733vomiting
voting103916033vo__ting
voyaging1632563voyaging
wetting114117383wet_ting
witting113417063wit_ting
womaning1437643womaning
wonting113214103wo_nting
worsting1267683worsting

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 Filter1786911461620.420425454.8
2DLD Change Limit1461623937.34619896.8
3Display Results3933930.1702311.8
 (SQL Overall)1786913937.93622516.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.