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 “satieties” 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
satieties93938(None) 
gaieties9310182ga_ieties
safeties1139162sa_feties
sanities81219772sani_ties
satiates8314632satiat_es
satinettes1043922satinettes
satisfies1245322satisfies
societies1148802societies
varieties1259202varieties
amities9317383_ami_ties
anxieties1646263anxieties
ariettes8411353_ariettes
asthenies1278063asthenies
batistes1039713batist_es
batteries11615113batteries
canities101519263cani_ties
catteries11815523catteries
catties94023053cat__ties
cavities131412613cavi_ties
dainties9312403da_inties
dubieties1245283dubieties
eateries8324313eat_eries
entireties1047273entireties
entities8617413enti_ties
fatties103018203fat__ties
fatuities1246913fatuities
gaseities1047083gaseities
gayeties1236883ga_yeties
impieties1345963impieties
laities7320343la_i_ties
latinities10410163latinities
laxities1539093laxi_ties
moieties10311263_moieties
naiveties1245433naiveties
nativities1348433nativities
nimieties1145223nimieties
parietes10714543pariet_es
parities10522973pari_ties
patiences1367433patiences
patooties1147183patooties
patties93425143pat__ties
pieties9419223__pieties
rarities8316333rari_ties
ratifies11313513rati_fies
ratites74920683rati_t_es
sacristies1276033sacristies
safetied1244663sa_fetied
saliences11108063saliences
saliencies1246133saliencies
salifies11314793sali_fies
salimetries1345693salimetries
salinities10410953salinities
salties73725773sa__lties
saltpetres1252463saltpetres
samites93118713sami_t_es
sanctities1247553sancti_ties
sanitise81511813sani_tise
sanitises91111743sani_tises
sanitizes181210133sani_tizes
sapidities1348003sapidities
sapiences13116423sapiences
sapiencies1445113sapiencies
satiate7315403satiat_e_
satiated9311603satiat_ed
satiating10311803satiating
satiation9313433satiation
satiations10312113satiations
satiety1038203satiet__y
satinets8311733satinet__s
satinette944553satinette_
satires72617573sati__res
satirise8310683sati_rise
satirises9410193satirises
satirizes1849393satirizes
satisfices1542763satisfices
satisfied1343873satisfied
satisfier1243733satisfier
satisfiers1342713satisfiers
satrapies1147713satrapies
sixties14310973s__ixties
sobrieties1244293sobrieties
sovietizes2243543sovietizes
staithes1138953stai_thes
statistics1244343statistics
statuettes1042923statuettes
steelies8312553s_teelies
stickies142211973s_tickies
stiffies14258383s_tiffies
stimies9316563s_ti_mies
stipites1039653s_tipites
stithies1139233s_tithies
suavities1248413suavi_ties
subtilties1246113subtilties
subtleties1245353subtleties
sureties8316583s_ureties
sweeties11159723s_weeties
tatties74120343tat__ties
titties73617363__titties
ubieties1046913_ubieties
vanities111414493vani_ties
vastities1248933vasti_ties

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 Filter1786911486410.420425454.8
2DLD Change Limit1486411017.65619415.0
3Display Results1011010.0462195.7
 (SQL Overall)1786911018.12222000.9
 
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.