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

319 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
knitting1325702(None) 
kitting123214441k_itting
knittings14273451knittings
knotting13236571knotting
bitting103717292_bitting
emitting112410352emitting
fitting113516562_fitting
flitting123010882flitting
fritting123510702fritting
gitting93215702_gitting
gritting10309982gritting
hitting113017272_hitting
kilting123213852k_ilting
kithing153411552k_ithing
kiting114117092k_i_ting
kitling123313572k_itling
kittling1336062k_ittling
knifing1536482kni_fing
knighting1844442knighting
knottings14243072knottings
knouting13226792knouting
netting84018762_netting
nutting83316232_nutting
omitting11217742omitting
pitting103618872_pitting
quitting18228832quitting
reknitting1584992reknitting
shitting123212662shitting
sitting83519632_sitting
slitting93012582slitting
spitting113012322spitting
twitting12307222twitting
unfitting1336422unfitting
uniting8315822uni_ting
unknitting1542872unknitting
unwitting1335582unwitting
witting113417062_witting
abetting1158293abetting
abutting1137003abutting
admitting1345033admitting
agisting1038243agisting
agitating1138863agitating
airting83616303_airting
animating12312513animating
anointing1038623anointing
anteing8312813an_teing
antiking13412073antiking
anting75827023an__ting
anything1534993anything
aviating12311023aviating
baiting103918883bai_ting
batting104422273_batting
befitting15236623befitting
beknotting1782813beknotting
betting103921403_betting
biting95321823_bi_ting
bittings11339293_bittings
blatting114111653blatting
blitzing2035903blitzing
blotting113910433blotting
brittling1235543brittling
butting103519283_butting
catting103922643_catting
chatting142810143chatting
chitling142910663chitling
citing94220183_ci_ting
clotting113110643clotting
cuittling1234103cuittling
cutting103817493_cutting
demitting13239073demitting
dieting93616833_dieting
dinting93520553_dinting
dittoing1036263_dittoing
dotting93314483_dotting
dratting10389653dratting
drifting13338733drifting
duetting1047183duetting
editing9313133edi_ting
enacting11311363enacting
enditing10311073enditing
enisling949633enisling
enlisting1038343enlisting
enticing11311803enticing
entitling1037103entitling
evicting1437483evicting
eviting11511373evi_ting
existing1639073existing
exiting15311393exi_ting
fainting123312163fainting
faithing1537153faithing
fatting113818703_fatting
feinting123410833feinting
fetting113517873_fetting
fisting113818123_fisting
fittings12318203_fittings
flatting123511253flatting
flinting123412343flinting
flirting12319013flirting
fliting113514613fli_ting
foisting122910503foisting
fretting122711523fretting
gaiting93716583gai_ting
getting93316563_getting
gifting123810893_gifting
girting93113333_girting
gittin72910553_gittin_
glinting103210053glinting
glitzing1934973glitzing
glutting10247643glutting
grifting13299263grifting
gutting93415923_gutting
hatting113920233_hatting
heisting123411043heisting
hilting113316893_hilting
hinting113919223_hinting
histing113720373_histing
hoisting123610903hoisting
hotting113116523_hotting
hutting113016033_hutting
igniting1037363igni_ting
imitating1238763imitating
inciting11312533inciting
indicting1339613indicting
inditing10312113inditing
ingoting1039863ingoting
initiating1149623initiating
inletting1087873inletting
inputting1235823inputting
insetting1079283insetting
insisting1038823insisting
instating10812213instating
intitling1037213intitling
inviting1239733inviting
jetting153815343_jetting
jilting153211743_jilting
jointing16248613jointing
joisting16328503joisting
jotting152912773_jotting
jutting153313713_jutting
karting123716063k_arting
kibitzing2542333kibitzing
kicking133314023k_icking
kidding14389773k_idding
killing123118723k_illing
kilning12289023k_ilning
kiltings13327083k_iltings
kindling14229623kindling
kinetin11248263kinetin_
kinetins12228153kinetins
kinging133115033k_inging
kinking113615153k_inking
kipping163311873k_ipping
kirning12319333k_irning
kissing122911053k_issing
kitlings13318103k_itlings
kitten104611483k_itten_
kittening1434593k_ittening
kittens11347583k_ittens
kitties113213623k_itties
knacking14296713knacking
knapping17314973knapping
kneading1436373kneading
kneeing12226523kn_eeing
kneeling13287783kneeling
knelling13319023knelling
knitted12337423knitt_ed
knitter11348133knitt_er
knitters12336623knitters
knocking14245943knocking
knolling13206893knolling
knottier12203983knottier
knottily1543153knottily
knowing15287683kn_owing
knurling1344943knurling
kything18285523k_ything
leniting9312353leni_ting
letting83218533_letting
lifting113313273_lifting
lilting83515383_lilting
linting83820983_linting
listing84020593_listing
lotting82917753_lotting
matting103620143_matting
milting103619123_milting
minting103020813_minting
minuting1139723minuting
misting103623383_misting
mitring103514143_mitring
nesting84320443_nesting
nettings9288103_nettings
nettling957213_nettling
nibbing12339553_nibbing
niching133612433_niching
nicking143516323_nicking
nictating1237573_nictating
nidating1039783_nidating
niding83217983_ni_ding
nighing123410063_nighing
nilling83619563_nilling
nimming12358143_nimming
nipping123412873_nipping
nitrating10312673_nitrating
nittier73512243_nittier
nixing143311493_ni_xing
notating92513343_notating
nothing113511903_nothing
noting74120153_n_oting
nutating92411953_nutating
nuttings9276783_nuttings
opiating11410093opiating
painting113614423painting
patting103722343_patting
petting103720953_petting
pithing134014053_pithing
pittings11349123_pittings
pitying132910243_pitying
platting114813033platting
plotting113011013plotting
pointing112813683pointing
potting103720893_potting
printing113216083printing
putting103218573_putting
quieting18228463quieting
quilting18218713quilting
quirting18238383quirting
ratting83822363_ratting
refitting132811123refitting
reknotting1564233reknotting
remitting122412623remitting
resitting103414873resitting
retting83425883_retting
rifting113515003_rifting
rioting82716393_rioting
rotting82919683_rotting
rutting82718043_rutting
sainting93215733sainting
sanitating1149653sanitating
scatting113311813scatting
setting83621393_setting
shifting152910383shifting
shirting123213613shirting
shotting123012383shotting
shutting12309693shutting
sifting113014593_sifting
silting83320483_silting
siting74126623_si_ting
sittings9339733_sittings
skirting13289393skirting
skiting123812503ski_ting
slatting94014233slatting
slotting92612613slotting
smiting103014443smi_ting
smutting11278063smutting
snibbing13295893snibbing
snicking153610233snicking
sniffing15227453sniffing
sniping103712053sni_ping
snipping13308853snipping
snitching1535913snitching
snooting92813203snooting
snorting92613373snorting
snouting92511923snouting
spatting113111763spatting
spirting112913633spirting
spiting103917623spi_ting
splitting1236563splitting
spotting112812093spotting
stetting93410713stetting
stilting93312403stilting
stinting93415743stinting
stotting92811163stotting
suiting83419003sui_ting
swatting12309593swatting
swotting12268483swotting
tainting93613583tainting
tatting84019523_tatting
tilting83417103_tilting
tincting1148883tincting
tinting84620603_tinting
tithing113513893_tithing
titling83715793_titling
toiting83217093toi_ting
totting82816843_totting
trithing122811773trithing
trotting92510913trotting
tutting83515913_tutting
twisting12427813twisting
unhatting1335873unhatting
unifying1537553unifying
unitizing1947803unitizing
unknotting1542663unknotting
unmitring1245263unmitring
unpitying1544043unpitying
unsetting1088993unsetting
unstating10711213unstating
unstring9312093unstring
untieing938863untieing
untiring9312003untiring
untying1138943un_tying
vatting113614853_vatting
vetting114216563_vetting
vittling1236143_vittling
waisting123615213waisting
waiting113618953wai_ting
wetting114117383_wetting
whetting1535973whetting
whisting15329543whisting
whiting143311303whi_ting
whittling1634383whittling
wilting113515913_wilting
wintling12249923wintling
wisting113519743_wisting
withing143814493_withing
witing103522823_wi_ting
witling113215813_witling
wittings12328733_wittings
wotting112913843_wotting
writhing15278673writhing
writing113713893wri_ting

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 Limit1461623197.21620255.3
3Display Results3193190.1432230.8
 (SQL Overall)1786913197.79522923.8
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2025  |  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.