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

359 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
twitting1230722(None) 
twisting12427811twisting
witting113417061_witting
bitting103717292_bitting
emitting112410352emitting
fitting113516562_fitting
flitting123010882flitting
fritting123510702fritting
gitting93215702_gitting
gritting10309982gritting
hitting113017272_hitting
kitting123214442_kitting
knitting13257022knitting
omitting11217742omitting
outwitting1445552outwitting
pitting103618872_pitting
quitting18228832quitting
shitting123212662shitting
sitting83519632_sitting
slitting93012582slitting
spitting113012322spitting
swatting12309592swatting
swotting12268482swotting
tainting93613582tainting
tatting84019522t_atting
tilting83417102t_ilting
tinting84620602t_inting
tithing113513892t_ithing
titling83715792t_itling
toiting83217092toi_ting
totting82816842t_otting
trithing122811772trithing
trotting92510912trotting
tutting83515912t_utting
twattling1332692twattling
tweeting12267032tweeting
twigging14305672twigging
twilling12268672twilling
twinging13278422twinging
twining113211442twi_ning
twinning12367042twinning
twirling12246242twirling
twistings13264352twistings
twitching1834242twitching
twittering1444582twittering
unwitting1335582unwitting
wetting114117382_wetting
wilting113515912_wilting
wisting113519742_wisting
withing143814492_withing
witing103522822_wi_ting
witling113215812_witling
wittings12328732_wittings
wotting112913842_wotting
abetting1158293abetting
abutting1137003abutting
admitting1345033admitting
agisting1038243agisting
agitating1138863agitating
airting83616303_airting
attritting1144763attritting
aviating12311023aviating
awaiting1238273awaiting
baiting103918883bai_ting
batting104422273_batting
befitting15236623befitting
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
dratting10389663dratting
drifting13338733drifting
duetting1047183duetting
dwining12269293dwi_ning
editing9313133edi_ting
entwisting1443853entwisting
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
imitating1238763imitating
intwisting1445063intwisting
jetting153815343_jetting
jilting153211743_jilting
jointing16248613jointing
joisting16328503joisting
jotting152912773_jotting
jutting153313713_jutting
kilting123213853_kilting
kithing153411553_kithing
kiting114117093_ki_ting
kitling123313573_kitling
kittling1336063_kittling
knittings14273453knittings
knotting13236573knotting
letting83218533_letting
lifting113313273_lifting
lilting83515383_lilting
linting83820983_linting
listing84020593_listing
lotting82917753_lotting
matting103620143_matting
milting103619123_milting
minting103020813_minting
misting103623383_misting
mitring103514143_mitring
netting84018763_netting
nutting83316233_nutting
opiating11410093opiating
outfitting1465823outfitting
outhitting1446333outhitting
outsitting1147133outsitting
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
remitting122412623remitting
resitting103414873resitting
retting83425883_retting
retwisting1445633retwisting
rewetting132710443rewetting
rifting113515003_rifting
rioting82716393_rioting
rotting82919683_rotting
rutting82718043_rutting
sainting93215733sainting
scatting113311813scatting
setting83621393_setting
shifting152910383shifting
shirting123213613shirting
shotting123012383shotting
shutting12309693shutting
sifting113014593_sifting
silting83320483_silting
siting74126623_si_ting
sittings9339733_sittings
skirting13289393skirting
skiting123812503ski_ting
slatting94014233slatting
slotting92612613slotting
smiting103014443smi_ting
smutting11278063smutting
spatting113111763spatting
spirting112913633spirting
spiting103917623spi_ting
splitting1236563splitting
spotting112812093spotting
stetting93410713stetting
stilting93312403stilting
stinting93415743stinting
stotting92811163stotting
striating10914193striating
strutting1037003strutting
suiting83419003sui_ting
swathing15248713swathing
sweating123213023sweating
sweeting123911313sweeting
swigging14337223swigging
swilling123511933swilling
swimming16316323swimming
swinging133411113swinging
swinking163410323swinking
swiping13319823swi_ping
swirling12249143swirling
swishing15277813swishing
switching1835703switching
swiving14358953swi_ving
tailing82923103tai_ling
tarting84222653t_arting
tasting84624213t_asting
tattings9408823t_attings
tattling9259473tattling
taunting93510933taunting
tauting83316383t_auting
teething1237163teething
tempting1357343tempting
tenting84621153t_enting
testing86021053t_esting
thieving1535143thieving
thinking16289863thinking
thinning12319093thinning
thirling12248583thirling
thirsting1335283thirsting
thwarting1632763thwarting
ticcing12308633t_iccing
ticking143218753t_icking
tiding83520093t_i_ding
tidying1238513t_idying
tieing73518763t_i_eing
tiering8315253t_iering
tiffing14339383t_iffing
tiling73426553t_i_ling
tilling83522783t_illing
timing93619303t_i_ming
tincting1148883tincting
tinging93619463t_inging
tining74927543t_i_ning
tinning83117283t_inning
tintings9288713t_intings
tipping122814973t_ipping
tiring74023093t_i_ring
tirling83315733t_irling
tithings12327693t_ithings
titrating10310113t_itrating
tittering102310313t_ittering
tittie63213153t_itti_e
titties73617363t_itties
tittuping1242453t_ittuping
toasting93410583toasting
toileting1036263toileting
toiling83219023toi_ling
toothing12278863toothing
tooting83019423t_ooting
tootling9279523tootling
toting74123793t__oting
touting84118453t_outing
treating92519613treating
triaging102610543triaging
tricing103417353tri_cing
tricking152714513tricking
trifling122411503trifling
trigging11299583trigging
trilling92815963trilling
trimming13318653trimming
trining82919213tri_ning
tripling112712553tripling
tripping133210923tripping
trithings13246603trithings
trothing122410843trothing
trusting93411653trusting
trysting12267053trysting
tufting11289873t_ufting
turtling9238833turtling
twanging13287063twanging
tweaking1635883tweaking
tweezing21384113tweezing
twiddling1543083twiddling
twillings13234913twillings
twingeing14143393twingeing
twinkling1743643twinkling
twinnings13253663twinnings
twistier1134813twistier
twitted11326633twitt_ed
twitter10278093twitt_er
twitters11296773twitters
twittery14303893twittery
tything14316573t_ything
unfitting1336423unfitting
uniting8315823uni_ting
untwisting1443943untwisting
vatting113614853_vatting
vetting114216563_vetting
vittling1236143_vittling
wafting143911663_wafting
waisting123615213waisting
waiting113618953_waiting
wanting114220173_wanting
wasting114422843_wasting
wattling12258783_wattling
weeting113816053_weeting
welting113615313_welting
westing115020273_westing
wettings12348403_wettings
whetting1535973whetting
whisting15329543whisting
whiting143311303_whiting
whittling1634383whittling
wicking173414773_wicking
wifing133513393_wi_fing
wigging133413833_wigging
wilding123814293_wilding
wiling103024293_wi_ling
willing113821613_willing
wimping153911013_wimping
wincing133413903_wincing
winding123517913_winding
winging123718713_winging
wining103625053_wi_ning
winking153317963_winking
winning113516553_winning
wintling12249923_wintling
wiping123916713_wi_ping
wiring104521023_wi_ring
wishing144114893_wishing
wising103318223_wi_sing
wisping133711943_wisping
wissing113212943_wissing
witching173410633_witching
within123611383_within_
withins133511693_withins
witlings12328443_witlings
wittier103910823_wittier
wittily1336173_wittily
wittingly1644803_wittingly
wiving133316603_wi_ving
wonting113214103_wonting
writhing15278673writhing
writing113713893_writing
wyting13277243_w_yting

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 Limit1461623597.06320694.0
3Display Results3593590.1402564.3
 (SQL Overall)1786913597.62623431.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.