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

504 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
dratting1038966(None) 
deratting1139511deratting
drafting13339411drafting
ratting83822361_ratting
batting104422272_batting
blatting114111652blatting
brattling1236002brattling
catting103922642_catting
chatting142810142chatting
crafting143710172crafting
crating103725202cra_ting
darting94020662d_arting
dartling1039562dartling
dating85326482d_a_ting
dauting93814762d_auting
dawting123610672d_awting
defatting1436102defatting
derating103222282dera_ting
doating93816862doa_ting
dotting93314482d_otting
drabbing14286802drabbing
draftings14334212draftings
dragging12308102dragging
draining103312672draining
dramming14347572dramming
draping114213352dra_ping
drawing123812052dra_wing
drawling13318672drawling
draying123813842dra_ying
drifting13338732drifting
duetting1047182duetting
fatting113818702_fatting
flatting123511252flatting
fretting122711522fretting
fritting123510702fritting
grafting13319622grafting
granting103514522granting
grating93923182gra_ting
gritting10309982gritting
hatting113920232_hatting
matting103620142_matting
orating83520322ora_ting
patting103722342_patting
platting114813032platting
prating103424452pra_ting
prattling1246302prattling
rafting113815752_rafting
ranting84025412_ranting
rating74938702_ra_ting
rattling92510872_rattling
retting83425882_retting
rotting82919682_rotting
rutting82718042_rutting
scatting113311812scatting
slatting94014232slatting
spatting113111762spatting
swatting12309592swatting
tatting84019522_tatting
trotting92510912trotting
vatting113614852_vatting
wrathing15248922wrathing
abating10413973aba_ting
abetting1158293abetting
abutting1137003abutting
acting95920983__acting
adapting1236643adapting
admitting1345033admitting
aerating92821003aera_ting
anting75827023__anting
awaiting1238273awaiting
baiting103918883_baiting
basting104227203_basting
bathing134816243_bathing
bating95132253_ba_ting
battings114010573_battings
battling113110493_battling
batwing13509813_batwing
beating104326873bea_ting
berating113220763bera_ting
betting103921403_betting
bitting103717293_bitting
blasting114013433blasting
blotting113910433blotting
boasting113512503boasting
boating103721303boa_ting
borating113414503bora_ting
bracing123817613bra_cing
bradding13268933bradding
bragging13359333bragging
braiding123112703braiding
brailing113514793brailing
braining113414683braining
braising113014563braising
braking143917713bra_king
branding122513683branding
branning112911093branning
brassing112612303brassing
brattice1245693brattice
bratticing1543923bratticing
brattier1047663brattier
brattish1346973brattish
braving133714613bra_ving
bravoing1445993bravoing
brawling143210043brawling
braying134416313bra_ying
brazing193715113bra_zing
breasting1239583breasting
breathing15218373breathing
brittling1235543brittling
bruiting11259973bruiting
bruting102612993br_uting
butting103519283_butting
canting104725903_canting
carting104228283_carting
casting104628343_casting
catling104819793_catling
chanting143413533chanting
charting142614193charting
clotting113110643clotting
coacting133412703coacting
coapting133511613coapting
coasting113615513coasting
coating103525313coa_ting
craaling112711353craaling
crabbing15287933crabbing
cracking174013903cracking
cradling122411453cradling
cramming15339433cramming
cramping153411853cramping
craning103620303cra_ning
cranking154613073cranking
craping124018713cra_ping
crapping153911453crapping
crashing143512633crashing
cratering12312653cratering
craving134015733cra_ving
crawling143110513crawling
crazing193914583cra_zing
creating113921953creating
cresting114017043cresting
crusting113612793crusting
curating11314293cura_ting
curetting1236573curetting
cutting103817493_cutting
dabbing133511233d_abbing
dadoing1038523d_adoing
daffing15369733d_affing
damming133812743d_amming
damning114211633d_amning
damping133414003d_amping
dancing113611563d_ancing
danging103716093d_anging
dapping133714793d_apping
daring84928683d_a_ring
darking134217343d_arking
darkling1437483darkling
darling93418363d_arling
darning93817333d_arning
dashing125917893d_ashing
daubing11358623d_aubing
daunting103310403daunting
dawing114819823d_a_wing
dawning124111013d_awning
dazing175516513d_a_zing
deairing10311893deairing
dealing94323233dea_ling
deaning94020473dea_ning
deashing134210953deashing
deaving123814753dea_ving
debating123213733debating
debiting122511203debiting
debuting12268633debuting
decanting132510633decanting
delating103119603delating
deleting103314423deleting
demasting1338453demasting
demitting13239073demitting
demoting12311423demoting
denoting10311753denoting
denting94422183d_enting
departing1349513departing
deputing12238793deputing
derailing112011313derailing
deranging1238063deranging
desalting1138843desalting
detracting1438713detracting
devoting1338823devoting
dialing94318173dia_ling
dialling10310783dialling
dictating1338883dictating
dieting93616833d_ieting
dighting142510843dighting
dilating102714913dilating
diluting10248983diluting
dinting93520553d_inting
directing1338823directing
dirtying1336093dirtying
disrating11714553disra_ting
dittoing1036263dittoing
donating10311803donating
doting84821913d__oting
doubting1237373doubting
drabbling1544553drabbling
draftier1285263draftier
draftily1534413draftily
draggling1354613draggling
dragline1036843dragline
drain65222893dra__in_
drains73719403dra__ins
drastic10310883drasti_c
dratted9358593dratt_ed
draughting1642883draughting
drawings13386283dra_wings
drawstring1542073drawstring
dreading113712803dreading
dreaming124011063dreaming
dredging12236423dredging
dreeing94311183dr_eeing
dressing102810423dressing
dribbing14325883dribbing
drilling103311983drilling
drinking14308913drinking
dripping14278033dripping
driving123910713dr_iving
drolling103510763drolling
droning93013723dr_oning
drooling102610423drooling
drooping12268803drooping
dropping14309283dropping
drouking1436443drouking
droving12379683dr_oving
drowning13298363drowning
drowsing13287773drowsing
drubbing14286053drubbing
drudging12256233drudging
drugging12326443drugging
drumming14265783drumming
drying113411603dr__ying
ducting113713593d_ucting
dueting93814393d_ueting
dunting93418383d_unting
dusting93618993d_usting
dwarfing1633613dwarfing
earthing12310333earthing
easting84924303_easting
eating75134403_ea_ting
elating83423083ela_ting
emitting112410353emitting
enacting11311363enacting
erasing8317963era_sing
erecting112415063erecting
eructing112110173eructing
erupting11218443erupting
estating92614993estating
exacting1838523exacting
exalting1638033exalting
farthing1538073farthing
farting114120753_farting
fasting114522833_fasting
fating105328673_fa_ting
fatling113815683_fatling
feasting122011323feasting
fetting113517873_fetting
fitting113516563_fitting
flatling123410013flatling
flitting123010883flitting
formatting1644163formatting
fragging14329423fragging
framing133014793fra_ming
franking164310863franking
frapping16348103frapping
fraying143413433fra_ying
fronting12310443fronting
frosting12311183frosting
frothing15208533frothing
fruiting12229063fruiting
gaiting93716583_gaiting
garoting10510703garoting
garotting1136113garotting
gasting95022763_gasting
gating84826953_ga_ting
getting93316563_getting
gitting93215703_gitting
glutting10247643glutting
grabbing14267313grabbing
gracing113216443gra_cing
gradating1237323gradating
grading103918713gra_ding
graining102813183graining
graphing1538533graphing
grasping12348833grasping
grassing103311973grassing
gratin74520583gra_tin_
gratine84719193gra_tine
gratings103910763gra_tings
gratins84119183gra_tins
graving123114563gra_ving
graying124115883gra_ying
grayling1338003grayling
grazing183514553gra_zing
greeting103112353greeting
grifting13299263grifting
grouting103410793grouting
grunting10269583grunting
gutting93415923_gutting
gyrating1337453gyra_ting
hafting144014173_hafting
halting114419073_halting
hanting114124483_hanting
hasting114725193_hasting
hating104929713_ha_ting
hearting12513123hearting
heating114024323hea_ting
hitting113017273_hitting
hotting113116523_hotting
hutting113016033_hutting
hydrating1746323hydra_ting
ideating10311703idea_ting
jetting153815343_jetting
jotting152912773_jotting
jutting153313713_jutting
karting123716063_karting
kitting123214443_kitting
knitting13257023knitting
knotting13236573knotting
kraaling13186663kraaling
lasting84725243_lasting
lathing114315693_lathing
lattin64316223_lattin_
lattins74115483_lattins
letting83218533_letting
loathing1247673loathing
lotting82917753_lotting
malting103219083_malting
marting103325013_marting
masting104325823_masting
mating94832913_ma_ting
mattin84416633_mattin_
mattings11369673_mattings
mattins93316143_mattins
moating104218153moa_ting
mutating112211753mutating
netting84018763_netting
notating92513343notating
nutating92411953nutating
nutting83316233_nutting
omitting11217743omitting
orbiting1138153orbiting
panting104025423_panting
parting103527383_parting
partying14168893partying
pasting103826553_pasting
petting103720953_petting
pirating11314513pira_ting
pitting103618873_pitting
plaiting113113513plaiting
planting113515383planting
plating103823073pla_ting
plotting113011013plotting
potting103720893_potting
praising113214563praising
prancing132612163prancing
pranging123012723pranging
pranking153813383pranking
prawning1446963prawning
praying133717323pra_ying
preacting142412533preacting
prettying1536043prettying
printing113216083printing
putting103218573_putting
quanting1849233quanting
quitting18228833quitting
racing95030533_ra_cing
racking144323663_racking
radding103715003_radding
ragging103516683_ragging
raging85126433_ra_ging
raiding93617593_raiding
railing83325643_railing
raining83922693_raining
raising83220533_raising
raking114728423_ra_king
ramming123115063_ramming
ramping123316873_ramping
ranging94120263_ranging
ranking124320883_ranking
raping94829853_ra_ping
rapping123619103_rapping
raring74332873_ra_ring
rasing74330833_ra_sing
rasping104316253_rasping
ratfink1434943_ratfink
ratine65131823_ra_tine
ratings84217413_ra_tings
ratlin64116523_ratlin_
ratline74517803_ratline
ratlins73615583_ratlins
rattan63613603_rattan_
rattans73411953_rattans
ratten64217383_ratten_
rattening10288763_rattening
rattens74213403_rattens
rattier74015593_rattier
rattish10510823_rattish
rattlings10235513_rattlings
ratton64116123_ratton_
rattons73815323_rattons
raving105128853_ra_ving
raxing144321023_ra_xing
raying105027193_ra_ying
razing164524543_ra_zing
razzing1636323_razzing
reacting113317893reacting
redrafting1545963redrafting
renting84026853_renting
resting85031183_resting
retying113213833_retying
rifting113515003_rifting
rioting82716393_rioting
roasting93012703roasting
rooting83522433_rooting
rotating92614553_rotating
routing83821093_routing
rusting83821263_rusting
salting84120793_salting
sating74735453_sa_ting
scanting113914763scanting
scarting113415263scarting
scathing14269703scathing
seating84130683sea_ting
setting83621393_setting
shafting15278683shafting
shitting123212663shitting
shotting123012383shotting
shutting12309693shutting
sitting83519633_sitting
skating123613853ska_ting
slanting94115093slanting
slating83724653sla_ting
slattings10346073slattings
slitting93012583slitting
slotting92612613slotting
smarting113212453smarting
smutting11278063smutting
spitting113012323spitting
splatting1235983splatting
spotting112812093spotting
sprattling1363053sprattling
squatting1934513squatting
starting93116173starting
stating83725163sta_ting
stetting93410713stetting
stotting92811163stotting
strutting1037003strutting
swathing15248713swathing
swotting12268483swotting
tarting84222653_tarting
tasting84624213_tasting
tattings9408823_tattings
tattling9259473_tattling
tauting83316383_tauting
toasting93410583toasting
totting82816843_totting
tracing103720153tra_cing
tracking153715463tracking
trading93517973tra_ding
traiking132511973traiking
trailing92916093trailing
training93015863training
tramming13279343tramming
tramping132711273tramping
trancing112812023trancing
trapping132911393trapping
trashing122613223trashing
trawling122710783trawling
treating92519613treating
trithing122811773trithing
trothing122410843trothing
truanting1035603truanting
trusting93411653trusting
trysting12267053trysting
tutting83515913_tutting
twattling1332693twattling
twitting12307223twitting
unhatting1335873unhatting
uprating11311113upra_ting
vetting114216563_vetting
wafting143911663_wafting
waiting113618953_waiting
wanting114220173_wanting
wasting114422843_wasting
wattling12258783_wattling
wetting114117383_wetting
whetting1535973whetting
witting113417063_witting
wotting112913843_wotting
wracking18349963wracking
wrapping16297623wrapping
wrastling1335523wrastling
wreathing16266313wreathing
wresting123811833wresting
writhing15278673writhing
writing113713893wr_iting
yeasting12188923yeasting

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.436409841.7
2DLD Change Limit1461625047.04620744.0
3Display Results5045040.2032482.8
 (SQL Overall)1786915047.68523251.9
 
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.