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 “satrapies” with Change Limit: [1] [2] [3] [4]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

62 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
satrapies114772(None) 
sarapes94617752sa_rap_es
satraps95011642satrap__s
scrapies124612492s_crapies
ataraxies1644723_ataraxies
ataxies142410013_at_axies
atopies92816433_at_opies
atrazines1846683_atrazines
atrophies14410103_atrophies
atropines1148883_atropines
atropins10410493_atropins
dataries9314033dat_aries
entropies11411033entropies
harpies123818323ha_r_pies
isotropies12206323isotropies
matrasses1157293matrasses
ratanies8312923rat_anies
sacralizes2148233sacralizes
safranines1344083safranines
safranins1244353safranins
salaries8319593sa_laries
sarape84817573sa_rap_e_
sassabies1144153sassabies
satiates8314633satia_tes
satieties939383satieties
satisfies1245323satisfies
satrap86212553satrap___
satrapy12497933satrap__y
saturates9811603satura_tes
sauries72821623saur__ies
scrapes116217663s_crap_es
scrapie115010953s_crapie_
seatrains947603seatra_ins
serapes95218103s_erap_es
sharpies13411233shar_pies
stapes85028733s_t_ap_es
staples93617213s_t_aples
statuaries1054603statuaries
steadies9311123s_teadies
strafes104516003s_tra_fes
strains74218153s_tra_ins
straits74916323s_tra_its
strakes114218073s_tra_kes
stranges94516763s_tranges
strapless1135793s_trapless
strapped1357823s_trapped
strapper1258093s_trapper
strappers1346743s_trappers
strappier1345143s_trappier
strappiest1444383s_trappiest
straps87721783s_trap__s
strasses81311443s_trasses
strawier1137493s_trawier
strawiest1237223s_trawiest
stripes95320573s_trip_es
stripier1058863s_tripier
stripiest1138023s_tripiest
strophes13310603s_trophes
therapies1447723therapies
trapes85024463__trap_es
watapes12228383wat_ap_es
wattapes1395253wattap_es

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 Limit148641628.28317945.3
3Display Results62620.0302066.7
 (SQL Overall)178691628.73320461.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.