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

129 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
auspices123644(None) 
aruspices1343351aruspices
auspice1136521auspice_
allspices1343092allspices
apices104916262a__pices
aspics104211562a_spic_s
aspires9612042a_spires
aspises9611642a_spises
auspicates1444912auspicates
cuspides13306942cuspides
haruspices1752222haruspices
hospices1587632hospices
justices1737522justices
muspikes1635242muspikes
spices104326032__spices
suspires1038202suspires
abscises1246233abscises
absences1247673absences
advices13136933a_dvices
airspaces1344503airspaces
allspice1243343allspice_
alpines94016193a_lpines
alsikes1137263als_ikes
amices105018013a__mices
apsides103911303aps_ides
arsines73518813ars_ines
ascites9312603a_scites
asdics9439863a_sdic_s
asides75118873a_s_ides
aspects1146743a_spects
aspic95114733a_spic__
aspire8612123a_spire_
aspired1068173a_spired
aspirer967903a_spirer
aspirers1066493a_spirers
aspis74618143a_spi__s
assizes1638453a_ssizes
atopies92816433atopi_es
audiles83112613au_diles
augites8312183au_gites
aunties73920073aunti_es
auricles10138333au_ricles
auspex1574793ausp__ex
auspicate1345743auspicate
auspicated1544303auspicated
auspicious1453493auspicious
avarices1337183avarices
buppies133011063buppi_es
busbies113011693busbi_es
busies85525263bus_i_es
bustics11810883bustic_s
caudices13337343cau_dices
caustics1237483caustic_s
coppices1638243coppices
culices113713123cu_lices
cuspids12427113cuspi_ds
cuspis105010703cuspi__s
despises1139433despises
despites11410313despites
espies83716803_espi_es
fustics1279593fustic_s
guppies123310523guppi_es
gussies82813303gussi_es
hospice14117063hospice_
huipiles1344423huipiles
huskies143212083huski_es
hussies103213293hussi_es
huswifes1742723huswifes
huswives1742933huswives
inspires1037623inspires
jaundices1942183jaundices
juices1549423ju__ices
jussives1833843jussives
justice1637423justice_
lupines93912503lu_pines
misprices1547913misprices
murices112612283mu_rices
musicks15297053mus_icks
musics103911783mus_ic_s
muskies133614673muski_es
muspike1536043muspike_
nutpicks1643423nutpicks
outpaces122411943outpaces
outprices1337623outprices
pumices1338273pu_mices
puppies103212623puppi_es
pussies93615693pussi_es
respaces12311043respaces
respires10311903respires
respites10513243respites
resplices1336623resplices
rustics9810733rustic_s
saices84221803__saices
sices75637273__s_ices
slices84022853__slices
spaces104722633__spaces
spicas104715823__spicas
spice95528813__spice_
spiced115218313__spiced
spicer104719313__spicer
spicers113815553__spicers
spicey134414233__spicey
spicks144814993__spicks
spics94123243__spic_s
spies76037623__spi_es
spikes124520713__spikes
spiles84227913__spiles
spines85132033__spines
spires84628113__spires
spites84127333__spites
splices113914383__splices
subspaces1545673subspaces
suffices16208183suffices
supines94216383su_pines
surplices1346043surplices
suspects1254863suspects
suspire937803suspire_
suspired1135613suspired
tushies10312163tushi_es
tussises835433tussises
umpires1137813_umpires
unpicks1545183_unpicks
unpiles92112783_unpiles
uppiles11208263_uppiles
upsides10319633_upsides
upsizes18297163_upsizes
usances967373_usances
wussies103411083wussi_es
yuppies14339263yuppi_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 Filter1786911461620.423422437.4
2DLD Change Limit1461621298.14017956.0
3Display Results1291290.0632047.6
 (SQL Overall)1786911298.62620715.4
 
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.