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

267 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
knotting1323657(None) 
knitting13257021knitting
knottings14243071knottings
knouting13226791knouting
beknotting1782812beknotting
blotting113910432blotting
clotting113110642clotting
dotting93314482_dotting
hotting113116522_hotting
jotting152912772_jotting
kitting123214442k_itting
knittings14273452knittings
knocking14245942knocking
knolling13206892knolling
knottier12203982knottier
knottily1543152knottily
knowing15287682kno_wing
lotting82917752_lotting
netting84018762_netting
notating92513342_notating
nothing113511902_nothing
noting74120152_no_ting
nutting83316232_nutting
plotting113011012plotting
potting103720892_potting
reknotting1564232reknotting
rotting82919682_rotting
shotting123012382shotting
slotting92612612slotting
snooting92813202snooting
snorting92613372snorting
snouting92511922snouting
spotting112812092spotting
stotting92811162stotting
swotting12268482swotting
totting82816842_totting
trotting92510912trotting
unknotting1542662unknotting
wotting112913842_wotting
abetting1158293abetting
aborting11710253aborting
abutting1137003abutting
adopting1237453adopting
allotting1046503allotting
annotating1146233annotating
anointing1038623anointing
anteing8312813an_teing
anting75827023an__ting
anything1534993anything
batting104422273_batting
besotting12256873besotting
betting103921403_betting
bitting103717293_bitting
blatting114111653blatting
bloating113512813bloating
boating103721303_boating
bolting104416763_bolting
boosting113311053boosting
booting103821363_booting
bottling11279143_bottling
butting103519283_butting
catting103922643_catting
chatting142810143chatting
clothing14278783clothing
clouting113011683clouting
coating103525313_coating
coopting133411313coopting
costing104323023_costing
coting94629253_co_ting
cutting103817493_cutting
denoting10311753deno_ting
doating93816863_doating
donating10311803donating
doting84821913_do_ting
dratting10389653dratting
duetting1047183duetting
emitting112410353emitting
emoting10313563emo_ting
enacting11311363enacting
enditing10311073enditing
enrooting10128133enrooting
fatting113818703_fatting
fetting113517873_fetting
fitting113516563_fitting
flatting123511253flatting
flitting123010883flitting
floating123111883floating
flouting122610473flouting
footing115017593_footing
footling12239923footling
fretting122711523fretting
fritting123510703fritting
fronting12310443fronting
frosting12311183frosting
frothing15208533frothing
garotting1136103garotting
gavotting1443193gavotting
getting93316563_getting
ghosting1336463ghosting
gitting93215703_gitting
gloating102611463gloating
glouting10379693glouting
glutting10247643glutting
gritting10309983gritting
grouting103410793grouting
gutting93415923_gutting
hatting113920233_hatting
hitting113017273_hitting
hooting113919883_hooting
hosting114318383_hosting
hutting113016033_hutting
inciting11312533inciting
inditing10312113inditing
ingoting1039863ingoting
inletting1087873inletting
inputting1235823inputting
insetting1079283insetting
instating10812213instating
intoning9311123intoning
intorting10311413intorting
inviting1239733inviting
jetting153815343_jetting
jolting153410913_jolting
jottings16275193_jottings
jutting153313713_jutting
karting123716063k_arting
keynoting1742813keyno_ting
kilting123213853k_ilting
kithing153411553k_ithing
kiting114117093k__iting
kitling123313573k_itling
kittling1336063kittling
knacking14296713knacking
knapping17314973knapping
kneading1436373kneading
kneeing12226523kn_eeing
kneeling13287783kneeling
knelling13319023knelling
knifing1536483kn_ifing
knighting1844443knighting
knotlike1144003knotlike
knotted12357233knott_ed
knotter11317643knott_er
knotters12276153knotters
knottiest13174563knottiest
knottiness1483593knottiness
knotty13315223knott__y
knowings16234043kno_wings
knurling1344943knurling
konking113510213k_onking
kotowing1634013k_otowing
kything18285523k_ything
letting83218533_letting
lofting113311313_lofting
looting83019643_looting
louting83719383_louting
matting103620143_matting
moating104218153_moating
molting103517173_molting
mooting103019363_mooting
mottling11197753_mottling
nesting84320443_nesting
nettings9288103_nettings
nettling957213_nettling
nocking143615113_nocking
nodding103811523_nodding
nogging103612723_nogging
noising83615173_noising
nooning83014853_nooning
noosing83315053_noosing
northing12199063_northing
noshing114612773_noshing
nosing73419843_no_sing
notching14288583_notching
nothings12266683_nothings
noticing1139453_noticing
nutating92411953_nutating
nuttings9276783_nuttings
omitting11217743omitting
opting94514403__opting
outing74128153__outing
patting103722343_patting
petting103720953_petting
photoing1439073photoing
pitting103618873_pitting
platting114813033platting
plotzing20276153plotzing
porting103021783_porting
posting105622243_posting
pouting103519943_pouting
putting103218573_putting
quitting18228833quitting
quoiting1836093quoiting
quoting17310043quo_ting
ratting83822363_ratting
reknitting1584993reknitting
repotting12511123repotting
retting83425883_retting
rioting82716393rio_ting
roosting93411463roosting
rooting83522433_rooting
rootling9269953rootling
rotating92614553_rotating
routing83821093_routing
rutting82718043_rutting
scatting113311813scatting
scooting113012643scooting
scouting112612753scouting
setting83621393_setting
shitting123212663shitting
shooting122812863shooting
shorting122514803shorting
shouting122711793shouting
shutting12309693shutting
sitting83519633_sitting
slatting94014233slatting
slitting93012583slitting
smutting11278063smutting
snogging11318043snogging
snooding102910433snooding
snooking133010583snooking
snooling93013473snooling
snooping113811323snooping
snoozing18319083snoozing
snoring83917203sno_ring
snottier8217383snottier
snottily1145553snottily
snowing113913453sno_wing
soothing12269973soothing
sooting82820963_sooting
sorting83221813_sorting
spatting113111763spatting
spitting113012323spitting
sporting112415463sporting
spouting113511953spouting
stetting93410713stetting
swatting12309593swatting
tatting84019523_tatting
toiting83217093_toiting
toothing12278863toothing
tooting83019423_tooting
tootling9279523tootling
toting74123793_to_ting
touting84118453_touting
trothing122410843trothing
tutting83515913_tutting
twitting12307223twitting
unbolting1236453unbolting
unbottling1343133unbottling
uncoating12611923uncoating
unfitting1336423unfitting
unhatting1335873unhatting
uniting8315823un_iting
unknitting1542873unknitting
unrooting1098833unrooting
unsetting1088993unsetting
unstating10711213unstating
unstring9312093unstring
untying1138943un_tying
unwitting1335583unwitting
vatting113614853_vatting
vetting114216563_vetting
voting103916033_vo_ting
wetting114117383_wetting
whetting1535973whetting
witting113417063_witting
wonting113214103_wonting

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.423422437.4
2DLD Change Limit1461622677.50019488.3
3Display Results2672670.1102427.3
 (SQL Overall)1786912678.03322244.6
 
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.