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

193 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
zymase20199748(None) 
zymases21938331zymases
cymae126713012cyma_e
cymas126417882cymas_
cymose13429652cymose
gyrase10508772gyrase
lyase85512412ly_ase
zygose19455552zygose
zyme1819114942zym__e
zymes1924712942zymes_
zymoses21608692zymoses
abase76023483_abase
admass957143admass
agmas85919873agmas_
almas76629773almas_
amas67746293_amas_
amass77119683_amass
amaze166016603_amaze
amuse75920833_amuse
amylase1237023amylase
apyrase1236363apyrase
atmas75721013atmas_
base64847023__base
bemas96424283bemas_
bemuse1038943bemuse
bimas95521743bimas_
blase75524233_blase
byname13256363byname
bypass1345043bypass
bypast13117373bypast
camas96333523camas_
camases114216343camases
camass104114183camass
camise103319633camise
case65848083__case
cease75227653_cease
chase105127123_chase
comade114415323comade
comae97128423coma_e
comake144413423comake
comas95833003comas_
comate104124843comate
comose105016843comose
crease85519573crease
cycas126513823cycas_
cycases1437533cycases
cyclase1436613cyclase
cyma116715843cyma__
cymar125711263cyma_r
cymars13599153cymars
cyme119420373cym__e
cymene1377393cymene
cymes1210118923cymes_
damage10410773damage
damask1335843damask
daymare1375633daymare
debase94014473debase
demast9517063demast
demise94618323demise
dumas85420433dumas_
dynast1088223dynast
ease45042333__ease
encase83714363encase
erase54925493_erase
eyas76427433ey_as_
eyases94513683ey_ases
eyass84410783ey_ass
eyras84715923eyras_
fease84824873_fease
female11310553female
gamas85431363gamas_
grease75416233grease
gymnast1344153gymnast
gyms107514593gym_s_
gyrases11368313gyrases
gyrate104912523gyrate
gyrose105310253gyrose
hamate113319833hamate
homage121210603homage
humane112812173humane
humate113214443humate
hydrase14287663hydrase
hylas114815903hylas_
hymns1337523hymns_
image81411293_image
immane1038883immane
incase83615283incase
inmate82917363inmate
kinase104210653kinase
lamas75532793lamas_
lase46148513__lase
lease55230263_lease
ligase7259913ligase
limas75627633limas_
lipase8239103lipase
lumas75622913lumas_
lyases95211873ly_ases
lyrate94112103lyrate
lysate9388103lysate
lyse76320593ly__se
mabe85733363__mabe
mace87345793__mace
made75440243__made
mae57659113__ma_e
maes66948403__maes
mage75739133__mage
make105537893__make
male66052303__male
mamas95930773mamas_
mane65052033__mane
manse75528233__manse
mare64759333__mare
marse76231153__marse
mas58175823__mas_
masa65034723__masa
maser75029973__maser
mash96039403__mash
mask105227363__mask
mass66044943__mass
masse75125293__masse
mast65959963__mast
mate65154223__mate
maze155434983__maze
mise66043583__mise
muse67136033__muse
mutase82811983mutase
myases113711553my_ases
myiases1235493myiases
mynas105815233mynas_
myomas1338303myomas_
nemas75321573nemas_
nomas74726413nomas_
ohmage1295063ohmage
omasa749483_omasa
osmose8108003osmose
pase65346863__pase
pease75231113_pease
phase104617213_phase
phrase11109903phrase
pimas94725103pimas_
please84315733please
pomace123111913pomace
pomade113611333pomade
prase76128753_prase
pumas95121563pumas_
pyas96225703py_as_
ramate83921683ramate
ramose8314403ramose
rase46149983__rase
remade94316983remade
remake124016113remake
remate84428683remate
remise84221953remise
rimose8310593rimose
ryas77224613ry_as_
simas75727553simas_
smash104814433_smash
smaze165012933_smaze
somas76030373somas_
synapse1234133synapse
tamale83717403tamale
tease55428713_tease
ukase9428493_ukase
uncase83817433uncase
unease63816643unease
unmade92911063unmade
unmake122811213unmake
unmask1265903unmask
urase54624683_urase
urease64516993urease
vamose1159283vamose
vase75629653__vase
xylose1636763xylose
yams95330733_yams_
yare75636943_y_are
yeas78638423_yeas_
yeast85327943_yeast
youse85322233_youse
zamias174212923zamias_
zas126946833z__as_
zetas145018163zetas_
zoeae144412483zoea_e
zoeas145815613zoeas_
zombie1937323zombie
zonae145116443zona_e
zonate154114923zonate
zouave1833573zouave
zygomas2243413zygomas_
zygoses20436783zygoses
zygote19325483zygote
zymogen2243693zymogen
zymosan2143803zymosan
zymosis21487493zymosis

Search took 5 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 Filter1786911127160.1401276364.3
2DLD Change Limit1127161934.67024136.2
3Display Results1931930.0633063.5
 (SQL Overall)1786911934.87336669.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.