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

514 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
rotating9261455(None) 
notating92513341notating
rotting82919681rot_ting
boating103721302bo_ating
borating113414502borating
bromating1439152bromating
coating103525302co_ating
corotating1349312corotating
doating93816862do_ating
donating10311802donating
dotting93314482dot_ting
estating92614992estating
hotting113116512hot_ting
iodating1038822iodating
jotting152912772jot_ting
locating11311502locating
lotting82917752lot_ting
moating104218152mo_ating
mutating112211752mutating
nutating92411952nutating
orating83520322_orating
potting103720892pot_ting
probating14311182probating
pronating12313762pronating
prorating12314282prorating
rating74938702r__ating
ratting83822362rat_ting
rebating112418342rebating
redating102620172redating
relating92725442relating
remating112322402remating
restating102319412restating
retaking133114272retaking
retaping113012552retaping
retasting102513412retasting
retaxing162311332retaxing
retting83425882ret_ting
roaming103215792ro_aming
roaring82916002ro_aring
roasting93012692roasting
roosting93411452roosting
rooting83522432ro_oting
rotation81615452rotation
rotations91613842rotations
rotative11310342rotative
rousting93913272rousting
routing83821092ro_uting
rutting82718042rut_ting
solating9315592solating
stating83725162_stating
totaling9610292totaling
totting82816842tot_ting
trotting92510912trot_ting
wotting112913842wot_ting
abating10413973_abating
ablating11311993ablating
abrogating1497983abrogating
actuating1239223actuating
aerating92820993aerating
agitating1138853agitating
annotating1146233annotating
arointing1049363arointing
aroynting1344633aroynting
arrogating121778383arrogating
astatine8313533astatine
aviating12311013aviating
bating95132253__bating
batting104422273bat_ting
beating104326873_beating
berating113220753berating
betaking153010143betaking
betting103921403bet_ting
bitting103717293bit_ting
blatting114111653blatting
bleating113514503bleating
bloating113512813bloating
blotting113910433blot_ting
boasting113512493boasting
boatings113710113bo_atings
bogarting1334653bogarting
bolting104416763bo_lting
boosting113311053boosting
booting103821363bo_oting
botching16359703botching
bottling11279143bottling
brocading1556253brocading
butting103519283but_ting
catting103922643cat_ting
chatting142810143chatting
cheating144014523cheating
cleating113518133cleating
clotting113110643clot_ting
coacting133412693coacting
coaling103722823co_aling
coaming123818323co_aming
coapting133511603coapting
coasting113615503coasting
coatings113811843co_atings
coaxing173511703co_axing
cogitating1447203cogitating
collating12312753collating
comaking1739983comaking
combating16310143combating
compting153013603compting
contacting15610063contacting
coopting133411313coopting
coronating13410153coronating
costing104323023co_sting
coting94629253co__ting
counting113115263counting
courting112514563courting
coveting141912303coveting
crating103725203_crating
creating113921953creating
cremating14312183cremating
croaking153712153cro_aking
curating11314293curating
cutting103817493cut_ting
dating85326483__dating
debating123213733debating
delating103119603delating
derating103222273derating
derogating1348623derogating
dictating1338883dictating
dilating102714903dilating
dotation91412733dotation
dotations101411633dotations
doting84821913do__ting
doubting1237373doubting
dratting10389653drat_ting
eating75134403__eating
elating83423083_elating
equating18310113equating
erotizing1949963erotizing
eructating1345683eructating
fating105328673__fating
fatting113818703fat_ting
fetting113517873fet_ting
fitting113516563fit_ting
fixating1936183fixating
flatting123511253flatting
floating123111883floating
foaling113515843fo_aling
foaming133612993fo_aming
foisting122910503foisting
foliating1339253foliating
footing115017593fo_oting
foraging1358063foraging
foraying1537433foraying
fretting122711523fret_ting
fritting123510703frit_ting
fronting12310443fro_nting
frosting12311183fro_sting
frothing15208533frot_hing
frowsting1634683frowsting
garotting1136103garot_ting
gating84826953__gating
gelating103015733gelating
gestating11229983gestating
getting93316563get_ting
gitting93215703git_ting
gloating102611463gloating
goading103112853go_ading
goaling93515333go_aling
gradating1237313gradating
grating93923183_grating
gritting10309983grit_ting
groaning102410283gro_aning
grouting103410793gro_uting
gutting93415923gut_ting
gyrating1337453gyrating
hating104929713__hating
hatting113920233hat_ting
heating114024323_heating
hitting113017273hit_ting
hoaxing18307763ho_axing
hoisting123610903hoisting
homaging1536613homaging
hooting113919873ho_oting
hosting114318383ho_sting
hotching17309313hotching
hutting113016033hut_ting
ideating10311703ideating
imitating1238763imitating
instating10812213instating
irritating1146283irritating
isolating1039743isolating
jetting153815343jet_ting
jointing16248613jointing
joisting16328503joisting
jolting153410913jo_lting
jottings16275193jot_tings
jousting16309353jousting
jutting153313713jut_ting
kitting123214443kit_ting
knotting13236573knot_ting
kotowing1634013kotowing
lactating1239183lactating
legating102313113legating
letting83218533let_ting
ligating102212283ligating
loading94114613lo_ading
loafing11319793lo_afing
loaming103613733lo_aming
loaning83614833lo_aning
loathing1247673loathing
lofting113311313lo_fting
looting83019643lo_oting
louting83719383lo_uting
luxating1645613luxating
mating94832913__mating
matting103620143mat_ting
metaling111613713metaling
moaning103714443mo_aning
molting103517173mo_lting
montaging1346543montaging
mooting103019363mo_oting
mortaring1237933mortaring
motivating1646803motivating
motiving1437163motiving
motoring11410953motoring
mottling11197753mottling
moulting112710313moulting
mounting112711813mounting
negating102012833negating
netting84018763net_ting
nictating1237573nictating
nidating1039773nidating
nitrating10312673nitrating
nonacting1238783nonacting
nonrotating1246303nonrotating
notation81414603notation
notations91512973notations
notching14288583notching
nothing113511903not_hing
noticing1139453noticing
noting74120153no__ting
nutting83316233nut_ting
oaring74225303_o_aring
okaying1534833_okaying
opiating11410093opiating
opting94514403_o_pting
orbiting1138153orbiting
ousting84021353_ousting
outacting1239213outacting
outdating11810863outdating
outeating10814493outeating
outing74128153_o_uting
outrating10916403outrating
ozonating1944323ozonating
patting103722343pat_ting
perorating13313123perorating
petting103720953pet_ting
phonating1537813phonating
pirating11314513pirating
pitting103618873pit_ting
plating103823073_plating
platting114813033platting
pleating112916053pleating
plotting113011013plot_ting
pointing112813683pointing
pomading1437423pomading
portaging1346843portaging
porting103021783po_rting
positing11312303positing
postdating1447163postdating
posting105622243po_sting
postmating1548603postmating
potation101716783potation
potations111615063potations
pouting103519943po_uting
prating103424453_prating
predating13514653predating
pretaping1439133pretaping
pretasting13239283pretasting
profaning1537293profaning
profiting1549983profiting
promoting1439913promoting
prompting1637193prompting
prostrating1449393prostrating
protamin121210543protamin_
protamine131310913protamine
protamins131410773protamins
protatic12314743protati_c
protecting151910203protecting
protesting131910253protesting
protonating1448583protonating
protracting1646923protracting
pupating1337683pupating
putting103218573put_ting
racing95030533r__acing
radiating111112123radiating
rafting113815753r_afting
raging85126433r__aging
raking114728413r__aking
ranting84025413r_anting
raping94829853r__aping
raring74332873r__aring
rasing74330833r__asing
ratine65131823r__atine
ratings84217403r__atings
rattling92510873rattling
ravaging1346323ravaging
raving105128853r__aving
raxing144321023r__axing
raying105027193r__aying
razing164524543r__azing
reacting113317893reacting
reading93327213r_eading
reaming103924013r_eaming
reaping103621213r_eaping
rearing83128783r_earing
reaving113820533r_eaving
rebaiting12311643rebaiting
recaning111416693recaning
recanting122414823recanting
recasting122414233recasting
reciting113118073reciting
recoating121317463recoating
recrating121318783recrating
redacting13612303redacting
reesting93118273reesting
refacing142512813refacing
reflating132514713reflating
refuting121911903refuting
regaling10315363regaling
regrating111316203regrating
reheating132314913reheating
relacing112516043relacing
relaxing162612633relaxing
relaying122515153relaying
relocating13310873relocating
remaking152613293remaking
renaming11313693renaming
renovating1447423renovating
renting84026853r_enting
repasting122312833repasting
repaving142810743repaving
repaying142712393repaying
repeating122618983repeating
replating122217393replating
repotting12511123repot_ting
reputing112412603reputing
resawing122311433resawing
resaying122512453resaying
reseating102421533reseating
resiting93521123resiting
reslating102516993reslating
resonating11311263resonating
restaging112410853restaging
restarting11310663restarting
resting85031183r_esting
retacking1658973retacking
retagging1236033retagging
retailing103214733retailing
retain64523283reta_in_
retaining102114733retaining
retains74522253reta_ins
retarding111110653retarding
retching143412173retching
reteaming122110443reteaming
retearing102214253retearing
retesting102614603retesting
retieing92913713retieing
retiling93319483retiling
retiming113014193retiming
retinting102215253retinting
retiring92717413retiring
retitling1039773retitling
retorting10613273retorting
retotaling1186883retotaling
retracing12313283retracing
retracting13311933retracting
retreating111414763retreating
retrying122410443retrying
retuning9311583retuning
retying113213833ret_ying
retyping14255613retyping
revoting12312033revoting
rewaking162310973rewaking
rewaxing19248563rewaxing
rifting113515003r_ifting
righting132610853righting
rioting82716393r_ioting
rivaling1239913rivaling
riveting12139443riveting
roaching143210433roaching
roarings9248283ro_arings
robbing123313213ro_bbing
robing93618003ro__bing
rocketing1666973rocketing
rocking143619633ro_cking
rockling15259383rockling
rodding103814533ro_dding
rodeoing1037253rodeoing
rogation91612053rogation
rogations101510823rogations
rogering10310273rogering
rogueing1054313rogueing
roguing9309563ro_guing
roiling83220453ro_iling
rolfing113710653ro_lfing
rolling83620413ro_lling
romaine9512123roma_ine
romancing1446043romancing
romping123113033ro_mping
roofing113814353ro_ofing
rooking123517363ro_oking
rooming104117043ro_oming
roosing84018133ro_osing
rootling9269953rootling
roping94023023ro__ping
roqueting1944603roqueting
rosing73925593ro__sing
rosining92411423rosining
rotaries8315693rotaries
rotate63320343rotat__e
rotated82715293rotat_ed
rotates72819773rotat_es
rotational1048083rotational
rotator7310823rotat_or
rotators8310183rotators
rotatory1147203rotatory
rototill844433rototill
rotten64115433rot_ten_
roughing13278343roughing
rouging93114703ro_uging
rounding102812283rounding
rouping103715793ro_uping
rousing83920553ro_using
routine72615903ro_utine
roving103618743ro__ving
roweling122811123roweling
rowing103623303ro__wing
ruinating1039593ruinating
rusting83821263r_usting
satiating10311803satiating
sating74735453__sating
scatting113311813scatting
seating84130683_seating
sedating103014113sedating
setting83621393set_ting
shotting123012363shot_ting
sitting83519633sit_ting
situating1038883situating
skating123613843_skating
slating83724653_slating
slatting94014233slatting
slotting92612603slot_ting
soaking123116613so_aking
soaping103616223so_aping
soaring83521893so_aring
solacing11310133solacing
solvating1336443solvating
sonatina849073sonatina
sonatine8313323sonatine
sooting82820953so_oting
sopiting11310763sopiting
sorting83221813so_rting
spatting113111763spatting
spotting112812083spot_ting
staging93818373_staging
staking123919803_staking
staling83925423_staling
staning83922243_staning
staring84527053_staring
starting93116173_starting
statin63921463_statin_
statins73719773_statins
staving113915703_staving
staying114017323_staying
stotting92811153stotting
swatting12309593swatting
sweating123213023sweating
swotting12268473swot_ting
taking114725953__taking
taming94023433__taming
taping94222393__taping
taring73932283__taring
tarting84222653__tarting
tasting84624213__tasting
tatting84019523__tatting
tauting83316383__tauting
tawing104521553__tawing
taxing143816713__taxing
throating1398383thro_ating
titrating10310113titrating
toasting93410573toasting
toiting83217093to_iting
tooting83019423to_oting
totalling1036513totalling
toting74123793__toting
touting84118453to_uting
treating92519613treating
troaking133310963tro_aking
trothing122410843trot_hing
tutting83515913tut_ting
unstating10711213unstating
updating1236593updating
uprating11311113uprating
urinating10310653urinating
vacating14310343vacating
vatting113614853vat_ting
vetting114216563vet_ting
violating1337423violating
vitiating1338403vitiating
vomiting1437733vomiting
voting103916033vo__ting
voyaging1632553voyaging
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.186960704.3
2DLD Change Limit1461625147.20320291.8
3Display Results5145140.2162379.6
 (SQL Overall)1786915147.60523496.5
 
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.