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
zymase20199747(None) 
zymases21938331zymases
cymae126713002cyma_e
cymas126417882cymas_
cymose13429652cymose
gyrase10508772gyrase
lyase85512412ly_ase
zygose19455532zygose
zyme1819114942zym__e
zymes1924712942zymes_
zymoses21608682zymoses
abase76023473_abase
admass957133admass
agmas85919873agmas_
almas76629773almas_
amas67746293_amas_
amass77119683_amass
amaze166016583_amaze
amuse75920823_amuse
amylase1236983amylase
apyrase1236343apyrase
atmas75721013atmas_
base64847013__base
bemas96424283bemas_
bemuse1038943bemuse
bimas95521743bimas_
blase75524213_blase
byname13256363byname
bypass1345043bypass
bypast13117363bypast
camas96333523camas_
camases114216323camases
camass104114183camass
camise103319613camise
case65848083__case
cease75227653_cease
chase105127123_chase
comade114415313comade
comae97128423coma_e
comake144413423comake
comas95832993comas_
comate104124803comate
comose105016813comose
crease85519563crease
cycas126513823cycas_
cycases1437523cycases
cyclase1436603cyclase
cyma116715843cyma__
cymar125711263cyma_r
cymars13599143cymars
cyme119420373cym__e
cymene1377393cymene
cymes1210118923cymes_
damage10410753damage
damask1335843damask
daymare1375623daymare
debase94014473debase
demast9517063demast
demise94618323demise
dumas85420433dumas_
dynast1088223dynast
ease45042333__ease
encase83714363encase
erase54925483_erase
eyas76427433ey_as_
eyases94513673ey_ases
eyass84410783ey_ass
eyras84715923eyras_
fease84824873_fease
female11310523female
gamas85431353gamas_
grease75416223grease
gymnast1344153gymnast
gyms107514593gym_s_
gyrases11368293gyrases
gyrate104912523gyrate
gyrose105310253gyrose
hamate113319783hamate
homage121210573homage
humane112812163humane
humate113214433humate
hydrase14287663hydrase
hylas114815903hylas_
hymns1337523hymns_
image81411283_image
immane1038863immane
incase83615273incase
inmate82917333inmate
kinase104210643kinase
lamas75532783lamas_
lase46148503__lase
lease55230263_lease
ligase7259903ligase
limas75627613limas_
lipase8239093lipase
lumas75622903lumas_
lyases95211873ly_ases
lyrate94112093lyrate
lysate9388093lysate
lyse76320593ly__se
mabe85733323__mabe
mace87345773__mace
made75440213__made
mae57659103__ma_e
maes66948383__maes
mage75739123__mage
make105537873__make
male66052283__male
mamas95930773mamas_
mane65052013__mane
manse75528213__manse
mare64759323__mare
marse76231143__marse
mas58175813__mas_
masa65034713__masa
maser75029973__maser
mash96039383__mash
mask105227353__mask
mass66044933__mass
masse75125293__masse
mast65959943__mast
mate65154213__mate
maze155434973__maze
mise66043573__mise
muse67136033__muse
mutase82811963mutase
myases113711553my_ases
myiases1235453myiases
mynas105815233mynas_
myomas1338293myomas_
nemas75321563nemas_
nomas74726413nomas_
ohmage1295053ohmage
omasa749483_omasa
osmose8108003osmose
pase65346863__pase
pease75231103_pease
phase104617193_phase
phrase11109873phrase
pimas94725103pimas_
please84315703please
pomace123111913pomace
pomade113611323pomade
prase76128753_prase
pumas95121563pumas_
pyas96225703py_as_
ramate83921633ramate
ramose8314373ramose
rase46149973__rase
remade94316963remade
remake124016083remake
remate84428643remate
remise84221933remise
rimose8310583rimose
ryas77224613ry_as_
simas75727553simas_
smash104814433_smash
smaze165012933_smaze
somas76030373somas_
synapse1234133synapse
tamale83717373tamale
tease55428713_tease
ukase9428493_ukase
uncase83817433uncase
unease63816633unease
unmade92911053unmade
unmake122811213unmake
unmask1265903unmask
urase54624663_urase
urease64516963urease
vamose1159263vamose
vase75629653__vase
xylose1636763xylose
yams95330733_yams_
yare75636933_y_are
yeas78638423_yeas_
yeast85327933_yeast
youse85322233_youse
zamias174212893zamias_
zas126946833z__as_
zetas145018163zetas_
zoeae144412483zoea_e
zoeas145815613zoeas_
zombie1937293zombie
zonae145116443zona_e
zonate154114913zonate
zouave1833573zouave
zygomas2243413zygomas_
zygoses20436773zygoses
zygote19325463zygote
zymogen2243693zymogen
zymosan2143803zymosan
zymosis21487473zymosis

Search took 6 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.1101624463.6
2DLD Change Limit1127161935.06022275.9
3Display Results1931930.0633063.5
 (SQL Overall)1786911935.23334147.0
 
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.