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

101 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
stithied123530(None) 
stithies1139231stithies
smithies1337912smithies
stimied10310622sti_mied
stitched14148202stitched
tithed104115592_tith_ed
citied94014143_cit_ied
faithed1437163faith_ed
kithed144613013_kith_ed
lithoed1137833_lithoed
pithed124615613_pith_ed
pithier123010293_pithier
pitied94017253_pit_ied
saithe94713913saith_e_
satisfied1343873satisfied
scathed134012643scath_ed
scythed16385303scyth_ed
seethed113410193seeth_ed
shied96125493s___hied
shimmied16294983shimmied
shinnied12345823shinnied
shithead1535523shithead
shitted114212053shit_ted
shittier1137313shittier
sighed113712053s_igh_ed
sighted123111523s_ighted
sited65130743s_it__ed
skited114313483skit__ed
skivvied1971813skivvied
slighted1357393slighted
slither104112983slith_er
slithered13136623slithered
slitted83513313slit_ted
slittier837003slittier
snitched14166863snitched
soothed113712743sooth_ed
sortied83314103sort_ied
southed114313993south_ed
spathed134013183spath_ed
spiffied17234823spiffied
spited94820443spit__ed
spitted103912703spit_ted
staithe1037723staith_e_
staithes1138953staith_es
stashed113812493stash_ed
stated75427833stat__ed
statued8459893stat_ued
steadied1036563steadied
stetted82610403stet_ted
stichic1446243stichi_c
sticked144114633sti_cked
stickier14229763stickier
stickies142211973stickies
stickled15298973stickled
stied65723033s__t_ied
stiffed14359583sti_ffed
stiffie13245773stiffie_
stiffies14258383stiffies
stifled113511093sti_fled
stilled83314793sti_lled
stillier868823stillier
stilted83511473sti_lted
stimies9316563sti_mies
stingier9279123stingier
stinkier12278543stinkier
stinted82914193sti_nted
stiped94517073sti__ped
stippled1345303stippled
stipuled1134453stipuled
stirred8359703sti_rred
stitcher13168393stitcher
stitches131410593stitches
stitching1547103stitching
stithy12398213stith__y
stithying1643703stithying
storied8515163st_oried
stotted83511423stot_ted
studied9268693st_udied
sturdied10215963sturdied
stymied1335663st_ymied
suited74019423suit__ed
swathed144611933swath_ed
swished14418843swish_ed
swishier1434563swishier
switched17157133switched
swithe124010683swith_e_
swither133710993swith_er
swithered16135463swithered
tidied83613273_ti_died
tithe85319703_tith_e_
tither94920283_tith_er
tithes94720213_tith_es
tithing113513893_tithing
titled73815003_tit_led
tittie63213153_tittie_
titties73617363_titties
tythed13457503_tyth_ed
withed134416233_with_ed
withier132910493_withier
withies133913543_withies
writhed14389623writh_ed

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 Limit1461621017.25020160.3
3Display Results1011010.0462195.7
 (SQL Overall)1786911017.73223110.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.