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

147 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
saxonies153791(None) 
agonies83016622_agonies
astonies8815102astonies
atonies75320952_atonies
axones134614512_axon_es
baronies10315022baronies
sanies63031952sa__nies
saponines1148042saponines
saponins1039452saponins
saponites1139942saponites
savories11311272savories
simonies10311112simonies
spoonies101911752spoonies
aconites10314353_aconites
adonis7314063_adoni_s
adonises92611433_adonises
agones75719863_agon_es
agonise83112693_agonise
agonises92613163_agonises
agonizes182610583_agonizes
anomies93316993_anomies
astonied978983astonied
atomies93918363_atomies
atones65225773_aton_es
atonias73315993_atonias
atonics93613713_atonics
atopies92816433_atopies
axone125918473_axon_e_
axonemes1744333_axonemes
axonic154312723_axoni_c
axons125517933_axon__s
balconies1347753balconies
baronnes1038553baronnes
betonies10413063betonies
boonies93422483_boonies
brionies10310543brionies
bryonies1336843bryonies
cajones163311333cajon_es
calories102919563calories
canonise10511093canonise
canonises11410803canonises
canonizes2049593canonizes
canonries1148413canonries
canopies12311853canopies
caponier1237883caponier
caponiers1345733caponiers
caponizes2238703caponizes
carnies94123963ca_rnies
colonies103620013colonies
conies84338593__conies
cronies9622513_cronies
ebonies9312883_ebonies
fannies103415643fa_nnies
felonies11310993felonies
goonies83618333_goonies
harmonies141311043harmonies
hexones17299143hexon_es
ironies7517423_ironies
isogonies10207263isogonies
jalopies1786673jalopies
laxities1539093laxities
loonies73919543_loonies
mahonias1348063mahonias
masonites1149173masonites
masonries1146853masonries
monies83233163__monies
nannies73015203na_nnies
parodies11313693parodies
peonies93620153_peonies
phonies123717513_phonies
ponies84833463__ponies
ratanies8312923ratanies
sabines94318483sabin_es
safeties1139163safeties
salaries8319593salaries
salifies11314793salifies
salines74029413salin_es
salinizes1839153salinizes
sallies73227813sa_llies
salmonids1245543salmonids
salons63823693salon__s
salties73725773sa_lties
saltines82917793saltines
sanes55649073sa__n_es
sanities81219773sanities
santonins948453santonins
saponifies1544713saponifies
saponify1644183saponify
saponin9310263saponi_n
saponine1039223saponine
saponite10410533saponite
sapotes9313943sapo_tes
sardines92815573sardines
sarodes84216143saro_des
sarongs84511803saron_gs
saroses73619333saro_ses
sassies74719263sa_ssies
satoris7317253satori_s
sauries72821623sa_uries
savines104417633savin_es
savorier1136643savorier
savoriest1246623savoriest
savouries1245473savouries
savvies1337603sa_vvies
sawbones13126643sawbon_es
sawflies1444743sawflies
saxes125229343sax___es
saxony1636233saxon__y
scammonies1643733scammonies
sconces113811453s_conces
scones84521303s_con_es
secondes1138133secondes
shannies113411263shannies
sheenies111411543sheenies
shinnies113010923shinnies
simonizes2047823simonizes
sixties14310973six_ties
sodomies11128553sodomies
sondes74922873s__ondes
sones55444143s__on_es
sonics84315633s__onics
sonnies7315223s_onnies
spadones1137253spadon_es
spinnies103210543spinnies
sponges10311043s_ponges
spoonier10167653spoonier
spooniest11178143spooniest
stogies8413693s_togies
stones65130033s_ton_es
stonier72013793s_tonier
stoniest8413543s_toniest
stoolies8311083stoolies
stories7324273s_tories
stramonies1246653stramonies
sweenies11148763sweenies
swoonier11185133swoonier
swooniest12176293swooniest
syntonies1248153syntonies
taconites1148473taconites
tawnies102812503ta_wnies
taxies135817333tax__ies
taxonomies1953643taxonomies
taxons134211503taxon__s
toonies73719883_toonies
twoonies1155693twoonies
valonias1147473valonias
zanies153219673za__nies

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.423422437.4
2DLD Change Limit1461621476.90621164.5
3Display Results1471470.0632333.3
 (SQL Overall)1786911477.39224173.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.