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

202 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
zany16731699(None) 
any68440491_any
many95731861many
wany106432361wany
aby810238062_aby
an211879082_an_
ana39559832_ana
and47244182_and
ane37866952_ane
ani37751182_ani
ant37270792_ant
awny105919302awny
ay511773892_a_y
azan136521782azan_
azans146516882azans
baby116723682baby
ban58366842ban_
band76740922band
bandy114824192bandy
bane65250432bane
bang74837012bang
bani65334962bani
bank105835752bank
bans66555142bans
banty106624002banty
barny105821732barny
bay89661642ba_y
bony96732082bony
cagy106321992cagy
caky136222442caky
can57760142can_
candy115119822candy
cane66653122cane
canny105817692canny
cans65050852cans
cant66362032cant
canty105226802canty
carny105822922carny
cavy125920002cavy
cay87155982ca_y
cony96537832cony
dan46859672dan_
dandy104416702dandy
dang65131552dang
dank95828242dank
dans56748152dans
davy116015522davy
day76254112da_y
deny86027122deny
easy76224492easy
fan67158862fan_
fancy134615482fancy
fane75343572fane
fang85432562fang
fanny114816042fanny
fano75831692fano
fans76247372fans
fawny144711712fawny
fay97454862fa_y
gaby107123192gaby
gamy105427532gamy
gan48060132gan_
gane55145302gane
gang66031982gang
gapy106320912gapy
gay76856492ga_y
hand86833712hand
handy125520872handy
hang85535562hang
hank115134142hank
hanky155418292hanky
hant75461592hant
hay97358772ha_y
hazy1918119192hazy
jane115031482jane
janty156816962janty
jay136242672ja_y
kana85928542kana
kane85133982kane
kay106745552ka_y
lacy95829632lacy
lady86527162lady
laky116725822laky
land56337312land
lane45153332lane
lang56637392lang
lank84734452lank
lanky125517482lanky
lawny115912012lawny
lay68865352la_y
lazy166423072lazy
liny78141332liny
luny77324132luny
man57465872man_
mana65341962mana
mane65052032mane
mangy115021252mangy
manly105022952manly
mano66536812mano
mans66354552mans
may88757632ma_y
mazy186419702mazy
meany104620482meany
mony96830012mony
nan37854882nan_
nana46632902nana
nancy105214922nancy
nanny84813812nanny
nans46139402nans
nary76931222nary
navy107518632navy
nay66952772na_y
oaky116419952oaky
pacy115328682pacy
paly95835532paly
pan58466452pan_
pandy115021172pandy
pane64950292pane
pang75336302pang
pans65855732pans
pansy105717972pansy
pant66061262pant
panty105929302panty
paty95234562paty
pay88461182pa_y
piny911838362piny
pony96434052pony
puny95526992puny
racy95825682racy
rainy85921082rainy
ran38266622ran_
rand55839572rand
randy95022082randy
rang56939172rang
rangy95320392rangy
rani46640112rani
rank85135532rank
rant45864682rant
ray66361992ra_y
sagy85327082sagy
sand55338472sand
sandy94221132sandy
sane45954342sane
sang55441242sang
sank85236832sank
sans45153362sans
say67264762sa_y
tan37167582tan_
tang56138692tang
tangy94519952tangy
tank85134032tank
tans46154832tans
tansy84514942tansy
tawny114713652tawny
tiny76134642tiny
tony75635152tony
van66246332van_
vane75534692vane
vang84926052vang
vans76236742vans
vary105226062vary
viny106025962viny
wady115325002wady
waly105830902waly
wan66761942wan_
wand85833882wand
wane76344722wane
waney115120322waney
wank115632512wank
wanly115118022wanly
wans76452272wans
want76156172want
wary106740012wary
wavy136620472wavy
waxy175918202waxy
way96757662wa_y
winy107034332winy
yang85626082yang
yank115423672yank
yay96948712ya_y
za1114939202za__
zag137539472za_g
zags146826682zags
zanily18310182zanily
zanza1378702zanza
zap145840692za_p
zappy21548942zappy
zaps156826892zaps
zarf166929122zarf
zas126946832za_s
zax197630632za_x
zin125643782zin_
zinc156819102zinc
zincy195413512zincy
zine137036162zine
zing145728622zing
zingy186516132zingy
zinky215314812zinky
zins135735012zins
zona136321962zona
zone135231082zone
zonk175018622zonk

Search took 2 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.280638182.1
2DLD Change Limit298722021.12326600.2
3Display Results2022020.0633206.3
 (SQL Overall)1786912021.466121890.2
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.