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

463 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
trotting9251091(None) 
rotting82919681_rotting
totting82816841t_otting
trothing122410841trothing
blotting113910432blotting
clotting113110642clotting
dotting93314482_dotting
dratting10389662dratting
fretting122711522fretting
fritting123510702fritting
fronting12310442fronting
frosting12311182frosting
frothing15208532frothing
garotting1136112garotting
gritting10309982gritting
grouting103410792grouting
hotting113116522_hotting
jotting152912772_jotting
knotting13236572knotting
lotting82917752_lotting
plotting113011012plotting
potting103720892_potting
ratting83822362_ratting
retting83425882_retting
rooting83522432_rooting
rotating92614552_rotating
routing83821092_routing
rutting82718042_rutting
shotting123012382shotting
slotting92612612slotting
spotting112812092spotting
stotting92811162stotting
strutting1037002strutting
swotting12268482swotting
tatting84019522t_atting
throating1398402throating
throttling1442792throttling
toiting83217092t_oiting
toothing12278862toothing
tooting83019422t_ooting
tootling9279522tootling
toting74123792t_o_ting
touting84118452t_outing
treating92519612treating
trithing122811772trithing
troaking133310972troaking
trocking153612422trocking
troking123514102tro_king
trolling93212492trolling
tromping13319602tromping
trooping112710282trooping
trotline8310022trotline
trouping11249502trouping
trowing113413702tro_wing
trusting93411652trusting
trysting12267052trysting
tutting83515912t_utting
twitting12307222twitting
wotting112913842_wotting
abetting1158293abetting
aborting11710253aborting
abutting1137003abutting
adopting1237453adopting
allotting1046503allotting
arointing1049363arointing
arousing93811803arousing
aroynting1344633aroynting
attritting1144763attritting
batting104422273_batting
besotting12256873besotting
betrothing1644673betrothing
betting103921403_betting
bitting103717293_bitting
blatting114111653blatting
bloating113512813bloating
boating103721303_boating
bolting104416763_bolting
boosting113311053boosting
booting103821363_booting
borating113414503borating
bottling11279143_bottling
brattling1236003brattling
brittling1235543brittling
broiling113112013broiling
broking143514823bro_king
bromating1439183bromating
bronzing2037693bronzing
brooding122911373brooding
brooking153710703brooking
brooming132911143brooming
browning14299643browning
browsing14319353browsing
bruiting11259973bruiting
bruting102612993br_uting
butting103519283_butting
catting103922643_catting
chatting142810143chatting
clothing14278783clothing
clouting113011683clouting
coating103525313_coating
coopting133411313coopting
corotating1349323corotating
costing104323023_costing
coting94629253_co_ting
crafting143710173crafting
crating103725203cr_ating
creating113921953creating
cresting114017043cresting
croaking153712163croaking
crocking174313443crocking
crooking153611343crooking
crooning113112113crooning
cropping153210893cropping
crossing112612693crossing
crostini1038293crostini
crostino1038883crostino
crowding15247933crowding
crowing133814763cro_wing
crowning143510033crowning
crusting113612793crusting
curetting1236573curetting
cutting103817493_cutting
deratting1139513deratting
doating93816863_doating
dogtrotting1462043dogtrotting
doting84821913_do_ting
drafting13339413drafting
drifting13338733drifting
drolling103510763drolling
droning93013723dro_ning
drooling102610423drooling
drooping12268803drooping
dropping14309283dropping
drouking1436443drouking
droving12379683dro_ving
drowning13298363drowning
drowsing13287773drowsing
duetting1047183duetting
emitting112410353emitting
emoting10313563emo_ting
enrooting10128133enrooting
erecting112415063erecting
eroding9314273ero_ding
erotizing1949963erotizing
eructing112110173eructing
erupting11218443erupting
fatting113818703_fatting
fetting113517873_fetting
fitting113516563_fitting
flatting123511253flatting
flitting123010883flitting
floating123111883floating
flouting122610473flouting
footing115017593_footing
footling12239923footling
foxtrotting2251733foxtrotting
frocking18309573frocking
frogging14358733frogging
frostings1335733frostings
frowning15307833frowning
frowsting1634683frowsting
fruiting12229063fruiting
garoting10510703garo_ting
garrotting1254203garrotting
gavotting1443193gavotting
getting93316563_getting
ghosting1336463ghosting
gitting93215703_gitting
gloating102611463gloating
glouting10379693glouting
glutting10247643glutting
grafting13319623grafting
granting103514523granting
grating93923183gr_ating
greeting103112353greeting
grifting13299263grifting
groaning102410283groaning
groining102310633groining
grokking1334813grokking
grooming12309513grooming
grooving13286713grooving
groping113313103gro_ping
grossing103111063grossing
grottier9316673grottier
grouping12308533grouping
grousing103410453grousing
growing123512473gro_wing
growling1348163growling
grunting10269583grunting
gutting93415923_gutting
hatting113920233_hatting
hitting113017273_hitting
hooting113919883_hooting
hosting114318383_hosting
hutting113016033_hutting
ironing82414013iro_ning
jetting153815343_jetting
jolting153410913_jolting
jottings16275193_jottings
jutting153313713_jutting
kitting123214443_kitting
knitting13257023knitting
knottings14243073knottings
knouting13226793knouting
letting83218533_letting
lofting113311313_lofting
looting83019643_looting
louting83719383_louting
matting103620143_matting
moating104218153_moating
molting103517173_molting
mooting103019363_mooting
mottling11197753_mottling
netting84018763_netting
northing12199063northing
notating92513343_notating
nothing113511903_nothing
noting74120153_no_ting
nutting83316233_nutting
omitting11217743omitting
opting94514403__opting
orating83520323or_ating
orbiting1138153orbiting
outing74128153__outing
outrooting1147933outrooting
outtrotting1244103outtrotting
patting103722343_patting
petting103720953_petting
photoing1439073photoing
pitting103618873_pitting
platting114813033platting
plotzing20276153plotzing
porting103021783_porting
posting105622243_posting
pouting103519943_pouting
prating103424453pr_ating
prattling1246303prattling
prettying1536043prettying
printing113216083printing
probating14311193probating
probing123314443pro_bing
prodding13189343prodding
profiting1549983profiting
progging132610383progging
promoing13310463promoing
promoting1439923promoting
prompting1637203prompting
pronating12313763pronating
pronging123511843pronging
proofing1439313proofing
propping122811673propping
prorating12314283prorating
prosing103319383pro_sing
protecting151910213protecting
protein92414733protein_
proteins102114283proteins
protesting131910253protesting
proving134214073pro_ving
prowling1449993prowling
putting103218573_putting
quitting18228833quitting
quoiting1836093quoiting
quoting17310043quo_ting
rafting113815753_rafting
ranting84025413_ranting
rating74938703_r_ating
rattling92510873_rattling
renting84026853_renting
repotting12511123repotting
rerouting10311873rerouting
resting85031183_resting
retying113213833_retying
rifting113515003_rifting
rioting82716393_rioting
roaming103215793_roaming
roaring82916003_roaring
roasting93012703_roasting
robbing123313213_robbing
robing93618003_ro_bing
rocking143619633_rocking
rodding103814533_rodding
roguing9309563_roguing
roiling83220453_roiling
rolfing113710653_rolfing
rolling83620413_rolling
romping123113033_romping
roofing113814353_roofing
rooking123517363_rooking
rooming104117043_rooming
roosing84018133_roosing
roosting93411463roosting
rootling9269953rootling
roping94023023_ro_ping
rosing73925593_ro_sing
rotten64115433_rotten_
rouging93114703_rouging
rouping103715793_rouping
rousing83920553_rousing
rousting93913273_rousting
routine72615903_routine
roving103618743_ro_ving
rowing103623303_ro_wing
rusting83821263_rusting
scatting113311813scatting
scooting113012643scooting
scouting112612753scouting
setting83621393_setting
shitting123212663shitting
shooting122812863shooting
shorting122514803shorting
shouting122711793shouting
shutting12309693shutting
sitting83519633_sitting
slatting94014233slatting
slitting93012583slitting
smutting11278063smutting
snooting92813203snooting
snorting92613373snorting
snouting92511923snouting
soothing12269973soothing
sooting82820963_sooting
sorting83221813_sorting
spatting113111763spatting
spitting113012323spitting
sporting112415463sporting
spouting113511953spouting
sprouting1236943sprouting
stetting93410713stetting
striating10914193striating
stroking132610943stro_king
strolling10238793strolling
stropping1436933stropping
strouding1136373strouding
strowing122310563stro_wing
stroying122410593stro_ying
strunting1037873strunting
swatting12309593swatting
tainting93613583tainting
targeting1137303targeting
tarting84222653t_arting
tasting84624213t_asting
tattings9408823t_attings
tattling9259473tattling
taunting93510933taunting
tauting83316383t_auting
teething1237163teething
tempting1357343tempting
tenting84621153t_enting
testing86021053t_esting
tholing112812333tho_ling
thorning1237513thorning
thouing11258603tho_uing
threating131010053threating
throbbing1743533throbbing
thronging1435073thronging
throning1238863thro_ning
throwing1536723thro_wing
thrusting1335013thrusting
tilting83417103t_ilting
tincting1148883tincting
tinting84620603t_inting
tithing113513893t_ithing
titling83715793t_itling
toasting93410583toasting
toeing74418473t_o_eing
togging103512743t_ogging
toiling83219023t_oiling
toking114420723t_o_king
toling73926123t_o_ling
tolling83418563t_olling
tombing123310533t_ombing
tomming12359243t_omming
tonging93314513t_onging
toning74025793t_o_ning
tontine72316143t_ontine
tooling82918313t_ooling
toping94122993t_o_ping
topping123514623t_opping
torching142510083torching
torquing1833843torquing
torturing1036253torturing
tossing83612563t_ossing
totaling9610303t_otaling
tottering10229613t_ottering
touring82915193t_ouring
tousing82916993t_ousing
towing103823193t_o_wing
toying105017303t_o_ying
tracing103720153tr_acing
tracking153715463tracking
trading93517973tr_ading
traiking132511973traiking
trailing92916093trailing
training93015863training
tramming13279343tramming
tramping132711273tramping
trancing112812023trancing
trapping132911393trapping
trashing122613223trashing
trawling122710783trawling
treading103515333treading
trebling1139873trebling
treeing83414303tr_eeing
trekking1235543trekking
trending103012833trending
triaging102610543triaging
tricing103417353tr_icing
tricking152714513tricking
trifling122411503trifling
trigging11299583trigging
trilling92815963trilling
trimming13318653trimming
trining82919213tr_ining
tripling112712553tripling
tripping133210923tripping
trithings13246603trithings
trollings10286693trollings
trollying1354053trollying
trophying1844713trophying
tropin83316753tro_pin_
tropine93116653tro_pine
tropins93116313tro_pins
trotlines939103trotlines
trotted83711283trott_ed
trotter73312253trott_er
trotters83310253trotters
troubling1234943troubling
trouncing1235153trouncing
troutier8277153troutier
troweling1376363troweling
truanting1035603truanting
trucing103211843tr_ucing
trucking153310163trucking
trudging11266443trudging
trueing83410183tr_ueing
truing73913933tr__uing
trumping13308733trumping
trussing9268653trussing
trying104214073tr__ying
tufting11289873t_ufting
turtling9238833turtling
tutoring938433tutoring
twattling1332693twattling
tweeting12267033tweeting
twisting12427813twisting
tything14316573t_ything
unrooting1098833unrooting
uprooting1276903uprooting
vatting113614853_vatting
vetting114216563_vetting
voting103916033_vo_ting
vrooming14287353vrooming
wetting114117383_wetting
whetting1535973whetting
witting113417063_witting
wonting113214103_wonting
worsting1267683worsting
worthing15178053worthing
wrathing15248923wrathing
wresting123811833wresting
writhing15278673writhing
writing113713893wr_iting
wronging13327393wronging

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.420425454.8
2DLD Change Limit1461624637.67319048.9
3Display Results4634630.1732676.3
 (SQL Overall)1786914638.26621617.6
 
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.