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

116 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
chittering1610718(None) 
chattering16108641chattering
bittering122511992_bittering
chaptering18107962chaptering
chartering16109252chartering
chippering2045162chippering
chitterlings1851412chitterlings
chuntering1647802chuntering
clattering13109232clattering
cluttering13106832cluttering
flittering1486502flittering
frittering14105622frittering
glittering1296002glittering
jittering17218422_jittering
littering102411982_littering
philtering1646252philtering
shattering1498282shattering
shuttering1496562shuttering
skittering1535392skittering
tittering102310312_tittering
twittering1444582twittering
battering122715143_battering
bettering122212753_bettering
blattering13108713blattering
blistering13107063blistering
blithering16116123blithering
buttering122312523_buttering
cantering122417373c_antering
catering112019903c__atering
centering122915143c_entering
chaffering22104643chaffering
chambering20116043chambering
chamfering21125333chamfering
chastening1656523chastening
chatting142810143chatt__ing
checkering2244403checkering
cheering143612703ch__eering
chequering2543123chequering
chickening2244133chickening
chiltepin1642893chiltepin_
chiltepins1753023chiltepins
chirring142610173chi__rring
chiseling1536403chi_seling
chitling142910663chi_t_ling
chitter124112963chitter___
chittered15166413chitter_ed
chitters133711173chitter__s
choppering2064813choppering
chowdering2044163chowdering
christening1743403christening
cindering13311223c_indering
ciphering17217703c_iphering
cittern9339143c_itter_n_
citterns10318123c_itter_ns
clinkering1745233clinkering
cloistering1444823cloistering
clustering13116813clustering
coinhering1647313coinhering
cointerring1447143cointerring
countering13314473countering
cratering12312653c_ratering
cuittling1234103cuitt_ling
dithering1499853_dithering
embittering1642943embittering
fettering132310513_fettering
filtering13199723_filtering
flattering1498743flattering
fluttering14106293fluttering
gettering112310033_gettering
glistering12106423glistering
guttering112410443_guttering
haltering132212003_haltering
hindering14310273_hindering
hitting113017273_hitt__ing
imbittering1642353imbittering
kittening1434593_kittening
leistering1147983leistering
lettering102112073_lettering
loitering1039683loi_tering
mattering122314053_mattering
mitering113015403_mi_tering
muttering122611323_muttering
nattering102212213_nattering
pattering122314423_pattering
philtring1544173philt_ring
pottering122612003_pottering
puttering122611643_puttering
reuttering1137573reuttering
roistering1148583roistering
scattering1398013scattering
scuttering1386633scuttering
sheltering1446493sheltering
shimmering1884623shimmering
shitting123212663shitt__ing
shivering1637333shi_vering
sintering101014803_sintering
sistering101213753_sistering
slithering1496893slithering
smattering1397583smattering
spattering13107793spattering
sputtering13106463sputtering
stuttering1196353stuttering
swithering17105213swithering
tattering102212323_tattering
tottering10229613_tottering
uttering91613083__uttering
waitering13310713wai_tering
whickering2343413whickering
whimpering2143853whimpering
whispering1944343whispering
whitening1635103whi_tening
whitewing1943853whi_tewing
whittling1634383whitt_ling
wintering13412363_wintering
withering16108813_withering
yattering132410443_yattering

Search took 7 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 Filter1786911406030.406440125.6
2DLD Change Limit1406031165.53325411.7
3Display Results1161160.0601933.3
 (SQL Overall)1786911165.99929786.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.