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

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

142 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
zymurgies24196315(None) 
chemurgies1852073chemurgies
liturgies1043463liturgies
murries94118663__murries
synergies1345073synergies
theurgies1343343theurgies
zymologies2546373zymologies
zymurgy2541013zymurg__y
allergies10137764allergies
ambries111614524_ambr_ies
anergies9310444_anergies
armories10313624armor_ies
armouries1146224armour_ies
armures9510274armur__es
auguries947914augur_ies
bougies103715174_bou_gies
budgies115312504__budgies
buggies114613814__buggies
burdies104117554__burdies
burgees104915884__burgees
burgles105615954__burgles
buries84633264__bur_ies
burnies94017794__burnies
byrnies12378564by__rnies
clergies1137904_clergies
curies84934014__cur_ies
curries93723154__curries
decuries11312204decur_ies
demerges12129504demerg_es
demiurges1343844demiurg_es
dhurries1255584_dhurries
druggies11126224_druggies
durries83817354__durries
dysurias1244454dysur_ias
emerges101310884_emerg_es
emeries91619994_emer_ies
energies9310764_energies
eyries93816804ey__r_ies
flurries11188884_flurries
furies95126374__fur_ies
gurges84716864__gurg_es
gurgles94312874__gurgles
gurries83515954__gurries
hierurgies1451544hierurgies
hourlies1138324_hourlies
hurdies114015654__hurdies
hurlies103315334__hurlies
hurries103919654__hurries
hymnaries1754284hymnaries
hymnodies18123974hymnodies
immerges1345374immerg_es
immures1136714immur__es
injuries1567674injur_ies
juries134120624__jur_ies
kauries113613164_kaur_ies
kyries133411374ky__r_ies
lemures938794lemur__es
lemuroids12113664lemuroids
liturgics1251894liturgics
luggies93011214__luggies
luxuries1544794luxur_ies
marges94525704__marg_es
margins103815154__margins
marries93825224__marries
memories121214304memor_ies
mercies113817534__mercies
mergees104411234__mergees
merges94122484__merg_es
micrurgies1552784micrurgies
moggies113111724__moggies
morgues1038274__morgues
muddies113513894__muddies
muggees11338874__muggees
muggier11288934__muggier
muggiest12228524__muggiest
muggins11248074__muggins
muhlies1238924__muhlies
mummies103812824__mummies
mungoes103510464__mungoes
mureins9310704__mureins
mures75937214__mur__es
murexes1636964__murexes
murices112612264__murices
murids93212184__mur_ids
murines93718184__murines
murkier133110254__murkier
murkiest143210254__murkiest
murphies1536414__murphies
murres85019044__mur_res
muskies133614634__muskies
myologies1539694myologies
orgies72316084___orgies
penuries10311644penur_ies
porgies103016984__porgies
purges94421764__purg_es
pyurias1236704py_ur_ias
reburies10311114rebur_ies
remarries1147614remarries
remerges111110194remerg_es
resurges9310114resurg_es
samurais1046084samurai_s
sauries72821594_saur_ies
scourges1136504scourg_es
scurries102911474_scurries
scurvies13248124_scurvies
slurries82710414_slurries
smarties10312844_smarties
smudges11348284_smudg_es
smudgier1233744_smudgier
smudgiest1334334_smudgiest
smuggles12225444_smuggles
snuggies10246354_snuggies
splurges1145144splurg_es
splurgier1252334splurgier
splurgiest1343204splurgiest
spurges104111654_spurg_es
spurries102311314_spurries
sturdies92110264_sturdies
surges73924564__surg_es
synergias1343414synergias
synergids1443004synergids
syzygies2441344sy_zygies
turgites937764__turgites
tympanies1644214tympanies
upsurges11144804upsurg_es
urges64619914___urg_es
usuries7510624_usur_ies
yearlies1137564_yearlies
yummies14359524_y_ummies
yuppies14339264_y_uppies
zombies2037984zom__bies
zombifies2543204zombifies
zoologies1938974zoologies
zymases21938334zym__ases
zymes1924712944zym____es
zymogen2243694zym_og_en
zymogenes2444454zymogenes
zymogens2343674zym_ogens
zymograms2643864zymograms
zymolyses2643124zymolyses
zymoses21608684zym__oses
zymosis21487474zym_osi_s

Search took 11 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 Filter1786911653290.1561145455.1
2DLD Change Limit16532914210.45315816.4
3Display Results1421420.0632254.0
 (SQL Overall)17869114210.67216743.9
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2023  |  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.