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

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

172 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
mazy18641969(None) 
hazy1918119191hazy
lazy166423071lazy
many95731841many
may88757621ma_y
maze155434971maze
aby810238062_aby
amaze166016602amaze
any68440482_any
ay511773892_a_y
azo128233392_azo
baby116723672baby
bay89661642ba_y
cagy106321992cagy
caky136222442caky
cavy125920002cavy
cay87155982ca_y
cozy185823802cozy
crazy195511222crazy
davy116015522davy
day76254112da_y
daze147327232daze
dozy175920322dozy
easy76224492easy
fay97454862fa_y
faze165630042faze
fozy197017162fozy
gaby107123192gaby
gamy105427532gamy
gapy106320912gapy
gauzy18489212gauzy
gay76856492ga_y
gaze145032412gaze
glazy187410982glazy
hay97358772ha_y
haze164833392haze
jay136242672ja_y
jazz193714462jazz
jazzy23396362jazzy
kay106745542ka_y
lacy95829632lacy
lady86527152lady
laky116725822laky
lay68865352la_y
laze136235052laze
ma410060652ma__
maar66025052maar
mabe85733342mabe
mac78053922ma_c
mace87345782mace
mach116134472mach
mack125733642mack
macs86742502macs
mad68958702ma_d
made75440232made
madly115218132madly
mads76845362mads
mae57659102ma_e
maes66948392maes
mag67956472ma_g
mage75739122mage
magi76329522magi
mags75444522mags
maid75537632maid
mail65543432mail
maim85831472maim
main65345502main
mair66133762mair
maize164618552maize
make105537882make
mako105622352mako
male66052292male
mall64639362mall
malm85129972malm
malmy124816342malmy
malt66254802malt
malty106721702malty
mama86231582mama
mamey125418832mamey
mammy115215162mammy
man57465852ma_n
mana65341942mana
mane65052012mane
mangy115021232mangy
manly105022942manly
mano66536792mano
mans66354532mans
map77255112ma_p
maps86141042maps
mar57965942ma_r
mara67444562mara
marc87034622marc
mare64759322mare
mark105138052mark
marl66341612marl
marly106925612marly
marry104821692marry
mars66261862mars
mart66865972mart
marvy135014032marvy
mas58175812ma_s
masa65034712masa
mash96039392mash
mashy136016502mashy
mask105227352mask
mass66044932mass
massy104518962massy
mast65959952mast
mat58083932ma_t
mate65154212mate
matey107022662matey
math95437442math
mats65460282mats
matt65752652matt
matza16311812matza
matzo16312892matzo
maud75325392maud
maul64830712maul
maun65727202maun
maut65448442maut
maw87050092ma_w
mawn94424132mawn
maws96437132maws
max129045442ma_x
maxi137023552maxi
maya95824582maya
mayo96524292mayo
mays96940022mays
mazed175523872mazed
mazer165722422mazer
mazes165632172mazes
mazily20610392mazily
mealy104422182mealy
meany104620472meany
meaty107021312meaty
meze154420902meze
miry96326742miry
mity95528202mity
moly96031912moly
mony96830002mony
mopy115721972mopy
mozo157719742mozo
muzzy188410602muzzy
my78125652m__y
nary76931222nary
navy107518632navy
nay66952772na_y
nazi136219872nazi
oaky116419952oaky
oozy167018132oozy
pacy115328682pacy
paly95835532paly
paty95234562paty
pay88461182pa_y
racy95825682racy
ray66361992ra_y
raze135235432raze
razz125219422razz
sagy85327082sagy
say67264762sa_y
sizy164816392sizy
smaze165012932smaze
vary105226062vary
wady115324992wady
waly105830902waly
wany106432352wany
wary106740012wary
wavy136620472wavy
waxy175918202waxy
way96757662wa_y
yay96948712ya_y
zany167316982zany

Search took 3 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 Filter178691298720.0632836365.1
2DLD Change Limit298721721.90615672.6
3Display Results1721720.0931849.5
 (SQL Overall)1786911722.06286659.1
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.