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

483 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
fretting12271152(None) 
fetting113517871f_etting
fritting123510701fritting
retting83425881_retting
abetting1158292abetting
befretting1644792befretting
betting103921402_betting
creating113921952creating
cresting114017042cresting
curetting1236572curetting
dratting10389662dratting
duetting1047182duetting
erecting112415062erecting
facetting1535282facetting
fatting113818702f_atting
felting113515212f_elting
feting104417792f_e_ting
fettling1266772f_ettling
fitting113516562f_itting
flatting123511252flatting
fleeting122910322fleeting
flitting123010882flitting
foresting13311362foresting
forgetting1544662forgetting
freaking163611452freaking
freeing113713912fre_eing
freezing21308322freezing
freshing152611022freshing
frettier1156592frettier
fronting12310442fronting
frosting12311182frosting
frothing15208532frothing
fruiting12229062fruiting
getting93316562_getting
greeting103112352greeting
gritting10309982gritting
jetting153815342_jetting
letting83218532_letting
netting84018762_netting
petting103720952_petting
prettying1536042prettying
ratting83822362_ratting
renting84026852_renting
resting85031182_resting
retying113213832_retying
rotting82919682_rotting
rutting82718042_rutting
setting83621392_setting
stetting93410712stetting
treating92519612treating
trotting92510912trotting
vetting114216562_vetting
wetting114117382_wetting
whetting1535972whetting
wresting123811832wresting
abutting1137003abutting
aerating92821003aerating
affecting1845233affecting
agenting1039383agenting
alerting91312383alerting
arresting1038633arresting
averting122512733averting
batting104422273_batting
beating104326873_beating
beetling1139283beetling
begetting13186583begetting
belting104119133_belting
berating113220763berating
berthing14209603berthing
besetting12268423besetting
besting104923923_besting
bitting103717293_bitting
blatting114111653blatting
bleating113514503bleating
blotting113910433blotting
brattling1236003brattling
breading123515463breading
breaking153914253breaking
breaming133612513breaming
breasting1239583breasting
breathing15218373breathing
breeding123411843breeding
breezing20368133breezing
breveting1536263breveting
brevetting1644333brevetting
brewing133411153bre_wing
brittling1235543brittling
bruiting11259973bruiting
bruting102612993br_uting
butting103519283_butting
catting103922643_catting
chatting142810143chatting
cheating144014523cheating
cleating113518143cleating
clefting14347583clefting
clotting113110643clotting
crafting143710173crafting
crating103725203cr_ating
creaking153414123creaking
creaming133413143creaming
creasing113314443creasing
creatin93618133creatin_
creatine103417413creatine
creatins103617513creatins
crediting1338843crediting
creeling113513363creeling
creeping133310103creeping
cremating14312203cremating
creping122913653cre_ping
crestings12298043crestings
cretin82917913cre_tin_
cretins93216423cre_tins
crewing133212633cre_wing
crusting113612793crusting
curvetting1643393curvetting
cutting103817493_cutting
denting94422183_denting
derating103222283derating
deratting1139513deratting
dieting93616833die_ting
directing1338823directing
dotting93314483_dotting
drafting13339413drafting
dreading113712803dreading
dreaming124011063dreaming
dredging12236423dredging
dreeing94311183dre_eing
dressing102810423dressing
drifting13338733drifting
dueting93814393due_ting
eating75134403__eating
effecting1845583effecting
egesting1039013egesting
ejecting18268163ejecting
electing112113783electing
emitting112410353emitting
eructing112110173eructing
erupting11218443erupting
everting122213133everting
exerting162211153exerting
faceting1438783faceting
fagoting1336283fagoting
fainting123312163fainting
faithing1537153faithing
farthing1538073farthing
farting114120753f_arting
fasting114522833f_asting
fating105328673f__ating
fatling113815683f_atling
faulting12237733faulting
fearing113520033f_earing
feasing113916653f_easing
feasting122011323feasting
feazing205411443f_eazing
feeding123515073f_eeding
feeing104416503f_e_eing
feeling113617073f_eeling
feezing204610163f_eezing
feinting123410833feinting
felling113321133f_elling
feltings12317903f_eltings
fencing132411133f_encing
fending123717603f_ending
fermenting1646823fermenting
ferreting13127703ferreting
ferrying15146253ferrying
feruling1258873feruling
fessing113812863f_essing
fetching17298413f_etching
fettering132310513f_ettering
fettlings1353753f_ettlings
feuding123410263f_euding
feuing104412273f_e_uing
fielding13206863fielding
fighting162710083fighting
fileting1239303fileting
firstling1334423firstling
fisting113818123f_isting
fittings12318203f_ittings
fixating1936183fixating
flatling123410013flatling
flecking18408233flecking
fledging14276523fledging
fleecing14347573fleecing
fleeing113511293fle_eing
fleering123811283fleering
flensing1246973flensing
fleshing15339303fleshing
fletching18256143fletching
flexing18358993fle_xing
fleying14329873fle_ying
flinting123412343flinting
flirting12319013flirting
fliting113514613f_liting
floating123111883floating
flouting122610473flouting
fluting113815093f_luting
flyting14378553f_lyting
foisting122910503foisting
fomenting1537233fomenting
footing115017593f_ooting
footling12239923footling
foredating1577123foredating
foredoing1456483foredoing
foregoing1455793foregoing
foretasting1554423foretasting
forewing1539003fore_wing
forfeiting1744133forfeiting
formatting1644163formatting
fragging14329423fragging
framing133014793fr_aming
franking164310863franking
frapping16348103frapping
fraying143413433fr_aying
freckling1934703freckling
freighting1844543freighting
frenching18267753frenching
frenzying2542413frenzying
frescoing1544683frescoing
fretted113411853frett_ed
fretter103412753frett_er
fretters113410303fretters
frettiest1267073frettiest
fretty1249223frett__y
friending1495553friending
frigging14268953frigging
frighting1736023frighting
frilling123011493frilling
fringing133010903fringing
frisking16268363frisking
frittering14105623frittering
frizing203310873fr_izing
frizzing2064803frizzing
frocking18309573frocking
frogging14358733frogging
frostings1335733frostings
frowning15307833frowning
frowsting1634683frowsting
frugging14317053frugging
frying134511403fr__ying
fueling113615133fue_ling
fuelling123410153fuelling
furcating1537783furcating
futzing20307903f_utzing
garotting1136113garotting
gazetting2043243gazetting
ghettoing1442123ghettoing
gitting93215703_gitting
gleeting10279173gleeting
glutting10247643glutting
grafting13319623grafting
granting103514523granting
grating93923183gr_ating
greasing102811393greasing
greeing93613783gre_eing
greening103112533greening
greetings11276043greetings
greying124110893gre_ying
grifting13299263grifting
grouting103410793grouting
grunting10269583grunting
guesting1058463guesting
gutting93415923_gutting
hatting113920233_hatting
heating114024323_heating
hefting144510913_hefting
henting113719653_henting
hitting113017273_hitting
hotting113116523_hotting
hutting113016033_hutting
ideating10311703ideating
inletting1087873inletting
insetting1079283insetting
jesting154317713_jesting
jettying1933953_jettying
jotting152912773_jotting
jutting153313713_jutting
kitting123214443_kitting
knitting13257023knitting
knotting13236573knotting
lotting82917753_lotting
matting103620143_matting
meeting103314963_meeting
melting103317753_melting
meriting11314693meriting
meting94320593_me_ting
metring103215293_metring
naething1236073naething
nesting84320443_nesting
nettings9288103_nettings
nettling957213_nettling
nutting83316233_nutting
offsetting1742333offsetting
omitting11217743omitting
orating83520323or_ating
orbiting1138153orbiting
orienting1038723orienting
parenting12611583parenting
pargetting1444943pargetting
patting103722343_patting
pelting102917273_pelting
pettings11349703_pettings
pettling1168213_pettling
pipetting1435513pipetting
pitting103618873_pitting
platting114813033platting
pleating112916053pleating
plotting113011013plotting
potting103720893_potting
prating103424453pr_ating
prattling1246303prattling
preacting142412533preacting
precutting1546423precutting
predating13514653predating
preeing103817673pre_eing
preening113115843preening
prepping12309763prepping
presetting131010833presetting
pressing112516443pressing
pretaping1439133pretaping
pretasting13239283pretasting
pretesting131810683pretesting
pretexting20206973pretexting
prettied1159253prettied
prettier1069043prettier
pretties10615133pretties
prettify1644343prettify
prettily1337283prettily
pretyping1764943pretyping
prevuing1457253prevuing
preying133114553pre_ying
priesting1239483priesting
printing113216083printing
putting103218573_putting
questing1838273questing
quitting18228833quitting
rafting113815753_rafting
ranting84025413_ranting
rating74938703_r_ating
rattling92510873_rattling
reacting113317893_reacting
reading93327213_reading
reaming103924013_reaming
reaping103621213_reaping
rearing83128783_rearing
reaving113820533_reaving
rebating112418343_rebating
rebutting1237523_rebutting
reciting113118073_reciting
recking144319923_recking
recutting1239483_recutting
redating102620173_redating
redding103218513_redding
reding83825563_re_ding
redoing93516733_redoing
redwing122811983_redwing
reeding94124133_reeding
reefing114016863_reefing
reeking123318643_reeking
reeling83126863_reeling
reesting93118273reesting
reeving113717663_reeving
reffing143712173_reffing
refitting132811123_refitting
refuting121911903_refuting
regretting1237783regretting
reining84425323_reining
reiving113316843_reiving
relating92725443_relating
reletting102713943reletting
relying112914613_relying
remating112322423_remating
remitting122412623_remitting
rending93924263_rending
repotting12511123_repotting
repping123314983_repping
reputing112412603_reputing
rerenting102617663rerenting
resetting102816293resetting
resiting93521123_resiting
resitting103414873_resitting
restating102319413_restating
restring91518783_restring
retain64523283_retain_
retains74522253_retains
retaking133114283_retaking
retaping113012553_retaping
retasting102513413_retasting
retaxing162311333_retaxing
retching143412173_retching
retesting102614603_retesting
rethink1488883_rethink
retieing92913713_retieing
retiling93319483_retiling
retiming113014193_retiming
retina65023383_re_tina
retine66237333_re_tine
retint65633443_re_tint
retinting102215253_retinting
retiring92717413_retiring
retitling1039773_retitling
retorting10613273_retorting
retrying122410453_retrying
retsina74710603_retsina
retuning9311583_retuning
retyping14255613_retyping
reusing82516783_reusing
revetting132912633revetting
revoting12312033_revoting
revving14379343_revving
rewetting132710443rewetting
rifting113515003_rifting
rioting82716393_rioting
rivetting13256413rivetting
rooting83522433_rooting
rotating92614553_rotating
routing83821093_routing
rusting83821263_rusting
scatting113311813scatting
scenting113212813scenting
seating84130683_seating
seething1239023seething
settings93810073_settings
settling978943_settling
sheeting122712833sheeting
shitting123212663shitting
shotting123012383shotting
shutting12309693shutting
sitting83519633_sitting
slatting94014233slatting
sleeting93114163sleeting
slitting93012583slitting
slotting92612613slotting
smelting11339713smelting
smutting11278063smutting
spatting113111763spatting
spitting113012323spitting
spotting112812093spotting
stotting92811163stotting
strutting1037003strutting
swatting12309593swatting
sweating123213023sweating
sweeting123911313sweeting
swotting12268483swotting
tatting84019523_tatting
teething1237163teething
tenting84621153_tenting
testing86021053_testing
threating131010053threating
totting82816843_totting
treading103515333treading
trebling1139873trebling
treeing83414303tre_eing
trekking1235543trekking
trending103012833trending
trithing122811773trithing
trothing122410843trothing
trusting93411653trusting
trysting12267053trysting
tutting83515913_tutting
tweeting12267033tweeting
twitting12307223twitting
unresting10311133unresting
unsetting1088993unsetting
upsetting1275563upsetting
vatting113614853_vatting
venting114218093_venting
vesting114618683_vesting
vetoing11309053_vetoing
weeting113816053_weeting
welting113615313_welting
westing115020273_westing
wettings12348403_wettings
witting113417063_witting
wotting112913843_wotting
wrathing15248923wrathing
wreaking163010213wreaking
wreathing16266313wreathing
wrecking18328153wrecking
wrestling1336063wrestling
writhing15278673writhing
writing113713893wr_iting
zesting174515333_zesting

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.423422437.4
2DLD Change Limit1461624837.23320207.7
3Display Results4834830.2032379.3
 (SQL Overall)1786914837.85922737.1
 
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.