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 “sixteen” 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
sixteen143411(None) 
sixteens1542941sixteens
fifteen1343922fifteen
sateen63815012s_ateen
sitten64113822si_tten
sixte126216582sixt_e_
sixteenmo185852sixteenmo
sixteenth1951682sixteenth
sixtes133612402sixt_es
sixties14310972sixties
subteen938522subteen
bitten84715123bi_tten
bittern94810683bittern
canteen9411083canteen
cistern93310703cistern
cittern9339143cittern
eighteen1245763eighteen
extern1348473_extern
fifteens1442753fifteens
giftee103512083giftee_
giftees11306513giftees
gittern8337503gittern
hitmen11239193hi_tmen
intern64016543_intern
ixtle12168013_ixtle_
ixtles13217063_ixtles
kitten104611483ki_tten
lateen64014863_lateen
liftmen1234233liftmen
listee64223063listee_
listees73416673listees
listen64816813list_en
litten64014873li_tten
mitten83914093mi_tten
nineteen844153nineteen
pitmen102510793pi_tmen
posteen93512623posteen
poteen83514263_poteen
potteen9319673potteen
preteen939873preteen
ratteen7329113ratteen
saltern74010653saltern
sateens73710753s_ateens
sauteed8349613sauteed
screen85216013s_creen
seen46943123s___een
settee63721023settee_
settees73513633settees
sextain14257103sextain
sextan13389643sext_an
sextet13916873sext_et
sextets1497143sextets
sexton133610793sext_on
shebeen1234553shebeen
sheen85023313s__heen
shotten10288463shotten
sickee124622223sickee_
sickees134514213sickees
sicken124615253si_cken
sidemen1037943sidemen
sifted104313673sift_ed
sifter94516233sift_er
sifters103714793sifters
sightseen1343193sightseen
signee73617233signee_
signees83510803signees
silken104410853si_lken
silted74020013silt_ed
siltier73413863siltier
silvern10347143silvern
sinter63625923sint_er
sintered92213903sintered
sinters74024083sinters
siree55238813si_ree_
sirees64624583si_rees
siren54525823si__ren
sirree64017343sirree_
sirrees73410573sirrees
sister64421583sist_er
sistered92612803sistered
sisters73721593sisters
site47052413si_t_e_
sited65130743si_t_ed
sites56045433si_t_es
sithens1039383si_thens
sitter63323383si_tter
sitters74221553sitters
sixes124526363six__es
sixpenny2041273sixpenny
sixteenmos195813sixteenmos
sixteenths2051233sixteenths
sixth155512233sixt__h
sixthly2042873sixthly
sixths16416373sixt_hs
sixtieth1842333sixtieth
sixty154912733sixt__y
skeen94817403s__keen
smitten936693smitten
soften9429493soft_en
spleen8310263s_pleen
steed66024943s__teed
steek95418003s__teek
steel55721993s__teel
steep76020703s__teep
steer55423863s__teer
stein54620543s__tein
stern55319123s__tern
subteens1037423subteens
suttee63721543suttee_
suttees74114063suttees
sweeten10267313sweeten
teen45938203___teen
thirteen1143303thirteen
titmen8239883ti_tmen
umpteen1143843umpteen
vixen153010023vix__en

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 Filter1786911340270.1561145455.1
2DLD Change Limit1340271167.03319056.9
3Display Results1161160.0462521.7
 (SQL Overall)1786911167.23524698.1
 
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.