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

311 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
many9573186(None) 
any68440491_any
man57465871man_
mana65341961mana
mane65052031mane
mangy115021241mangy
manly105022951manly
mano66536811mano
mans66354551mans
may88757631ma_y
mazy186419701mazy
meany104620481meany
mony96830011mony
wany106432361wany
zany167316991zany
aby810238062_aby
an211879082_an_
ana39559832_ana
and47244172_and
ane37866952_ane
ani37751182_ani
ant37270792_ant
awny105919302awny
ay511773892_a_y
baby116723682baby
ban58366842ban_
band76740912band
bandy114824182bandy
bane65250432bane
bang74837002bang
bani65334962bani
bank105835752bank
bans66555142bans
banty106624002banty
barny105821732barny
bay89661642ba_y
bony96732082bony
cagy106321992cagy
caky136222442caky
can57760142can_
candy115119822candy
cane66653122cane
canny105817692canny
cans65050852cans
cant66362032cant
canty105226802canty
carny105822922carny
cavy125920002cavy
cay87155982ca_y
cony96537832cony
dan46859672dan_
dandy104416702dandy
dang65131542dang
dank95828242dank
dans56748152dans
davy116015522davy
day76254112da_y
deny86027122deny
easy76224492easy
fan67158862fan_
fancy134615482fancy
fane75343572fane
fang85432552fang
fanny114816042fanny
fano75831692fano
fans76247372fans
fawny144711712fawny
fay97454862fa_y
gaby107123192gaby
gamy105427532gamy
gan48060132gan_
gane55145302gane
gang66031972gang
gapy106320912gapy
gay76856492ga_y
hand86833712hand
handy125520872handy
hang85535552hang
hank115134142hank
hanky155418292hanky
hant75461592hant
hay97358772ha_y
hazy1918119192hazy
jane115031482jane
janty156816962janty
jay136242672ja_y
kana85928532kana
kane85133972kane
kay106745542ka_y
lacy95829632lacy
lady86527152lady
laky116725822laky
land56337312land
lane45153332lane
lang56637382lang
lank84734452lank
lanky125517482lanky
lawny115912012lawny
lay68865352la_y
lazy166423072lazy
liny78141322liny
luny77324132luny
ma410060662ma__
maar66025062maar
mabe85733362mabe
mac78053932ma_c
mace87345792mace
mach116134482mach
mack125733652mack
macs86742512macs
mad68958712ma_d
made75440242made
madly115218132madly
mads76845372mads
mae57659112ma_e
maes66948402maes
mag67956482ma_g
mage75739132mage
magi76329532magi
mags75444532mags
maid75537662maid
mail65543452mail
maim85831492maim
main65345522main
mainly11411492mainly
mains75635112mains
mair66133782mair
make105537892make
mako105622362mako
male66052302male
mall64639372mall
malm85129982malm
malmy124816342malmy
malt66254812malt
malty106721702malty
mama86231592mama
mamey125418832mamey
mammy115215162mammy
manas76240432manas
manat76039992manat
maned86634102maned
manes76648962manes
manga85026202manga
mange84930192mange
mangey123614522mangey
mango85724322mango
mania75634152mania
manic94629442manic
manna75522542manna
manor78023932manor
manos74933622manos
manse75528232manse
manta75629912manta
manus75924932manus
map77255122ma_p
maps86141052maps
mar57965952ma_r
mara67444572mara
marc87034632marc
mare64759332mare
mark105138062mark
marl66341622marl
marly106925612marly
marry104821692marry
mars66261872mars
mart66865982mart
marvy135014032marvy
mas58175822ma_s
masa65034722masa
mash96039402mash
mashy136016502mashy
mask105227362mask
mass66044942mass
massy104518962massy
mast65959962mast
mat58083942ma_t
mate65154222mate
matey107022662matey
math95437452math
mats65460292mats
matt65752662matt
maud75325402maud
maul64830722maul
maun65727212maun
maund85515452maund
maundy12506782maundy
maut65448452maut
maw87050102ma_w
mawn94424142mawn
maws96437142maws
max129045452ma_x
maxi137023562maxi
maya95824592maya
mayo96524302mayo
mays96940032mays
maze155434982maze
mealy104422182mealy
mean65538092mean_
meanly115412042meanly
means75831232means
meant76537212meant
meaty107021312meaty
meiny104015412meiny
men59252852men_
mend75334032mend
meno66031362meno
menu65130232menu
mina65136922mina
mincy125817412mincy
mind75434382mind
mine67256172mine
mingy115520182mingy
mini65634562mini
mink106636532mink
minny104518662minny
mint66758062mint
minty106323902minty
minx137723352minx
miry96326752miry
mity95528212mity
moan65832022moan_
moans74624372moans
moly96031912moly
mon57561582mon_
money104826842money
monk105928522monk
mono66036722mono
mons68152262mons
moony104818272moony
mopy115721972mopy
mun56143862mun_
muni65824412muni
muns65535922muns
my78125652m__y
myna95815302myna
nan37854882nan_
nana46632902nana
nancy105214922nancy
nanny84813812nanny
nans46139402nans
nary76931222nary
navy107518632navy
nay66952772na_y
oaky116419952oaky
pacy115328682pacy
paly95835532paly
pan58466452pan_
pandy115021172pandy
pane64950292pane
pang75336292pang
pans65855732pans
pansy105717972pansy
pant66061262pant
panty105929302panty
paty95234562paty
pay88461182pa_y
piny911838352piny
pony96434052pony
puny95526992puny
racy95825682racy
rainy85921082rainy
ran38266622ran_
rand55839572rand
randy95022082randy
rang56939162rang
rangy95320382rangy
rani46640112rani
rank85135532rank
rant45864682rant
ray66361992ra_y
sagy85327082sagy
sand55338472sand
sandy94221132sandy
sane45954342sane
sang55441232sang
sank85236832sank
sans45153362sans
say67264762sa_y
tan37167572tan_
tang56138672tang
tangy94519932tangy
tank85134022tank
tans46154822tans
tansy84514932tansy
tawny114713652tawny
tiny76134632tiny
tony75635152tony
van66246332van_
vane75534692vane
vang84926042vang
vans76236732vans
vary105226062vary
viny106025952viny
wady115324992wady
waly105830902waly
wan66761942wan_
wand85833882wand
wane76344722wane
waney115120322waney
wank115632512wank
wanly115118022wanly
wans76452272wans
want76156172want
wary106740012wary
wavy136620472wavy
waxy175918202waxy
way96757662wa_y
winy107034322winy
yang85626072yang
yank115423672yank
yay96948712ya_y

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.266671770.7
2DLD Change Limit298723110.93631914.5
3Display Results3113110.0634936.5
 (SQL Overall)1786913111.265141257.7
 
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.