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
zany16731698(None) 
any68440481_any
many95731841many
wany106432351wany
aby810238062_aby
an211879072_an_
ana39559822_ana
and47244162_and
ane37866942_ane
ani37751172_ani
ant37270782_ant
awny105919302awny
ay511773892_a_y
azan136521782azan_
azans146516882azans
baby116723682baby
ban58366832ban_
band76740902band
bandy114824182bandy
bane65250422bane
bang74836992bang
bani65334952bani
bank105835742bank
bans66555132bans
banty106624002banty
barny105821732barny
bay89661642ba_y
bony96732082bony
cagy106321992cagy
caky136222442caky
can57760132can_
candy115119822candy
cane66653112cane
canny105817692canny
cans65050842cans
cant66362022cant
canty105226802canty
carny105822922carny
cavy125920002cavy
cay87155982ca_y
cony96537832cony
dan46859662dan_
dandy104416702dandy
dang65131532dang
dank95828232dank
dans56748142dans
davy116015522davy
day76254112da_y
deny86027122deny
easy76224492easy
fan67158852fan_
fancy134615482fancy
fane75343562fane
fang85432542fang
fanny114816042fanny
fano75831682fano
fans76247362fans
fawny144711712fawny
fay97454862fa_y
gaby107123192gaby
gamy105427532gamy
gan48060122gan_
gane55145292gane
gang66031962gang
gapy106320912gapy
gay76856492ga_y
hand86833702hand
handy125520872handy
hang85535542hang
hank115134132hank
hanky155418292hanky
hant75461582hant
hay97358772ha_y
hazy1918119192hazy
jane115031472jane
janty156816962janty
jay136242672ja_y
kana85928522kana
kane85133962kane
kay106745542ka_y
lacy95829632lacy
lady86527152lady
laky116725822laky
land56337302land
lane45153322lane
lang56637372lang
lank84734442lank
lanky125517482lanky
lawny115912012lawny
lay68865352la_y
lazy166423072lazy
liny78141322liny
luny77324132luny
man57465852man_
mana65341942mana
mane65052012mane
mangy115021232mangy
manly105022942manly
mano66536792mano
mans66354532mans
may88757622ma_y
mazy186419692mazy
meany104620472meany
mony96830002mony
nan37854872nan_
nana46632892nana
nancy105214922nancy
nanny84813812nanny
nans46139392nans
nary76931222nary
navy107518632navy
nay66952772na_y
oaky116419952oaky
pacy115328682pacy
paly95835532paly
pan58466442pan_
pandy115021172pandy
pane64950282pane
pang75336282pang
pans65855722pans
pansy105717972pansy
pant66061252pant
panty105929302panty
paty95234562paty
pay88461182pa_y
piny911838352piny
pony96434052pony
puny95526992puny
racy95825682racy
rainy85921082rainy
ran38266612ran_
rand55839562rand
randy95022082randy
rang56939152rang
rangy95320382rangy
rani46640102rani
rank85135522rank
rant45864672rant
ray66361992ra_y
sagy85327082sagy
sand55338462sand
sandy94221132sandy
sane45954332sane
sang55441222sang
sank85236822sank
sans45153352sans
say67264762sa_y
tan37167562tan_
tang56138662tang
tangy94519932tangy
tank85134012tank
tans46154812tans
tansy84514932tansy
tawny114713652tawny
tiny76134632tiny
tony75635152tony
van66246322van_
vane75534682vane
vang84926032vang
vans76236722vans
vary105226062vary
viny106025952viny
wady115324992wady
waly105830902waly
wan66761932wan_
wand85833872wand
wane76344712wane
waney115120322waney
wank115632502wank
wanly115118022wanly
wans76452262wans
want76156162want
wary106740012wary
wavy136620472wavy
waxy175918202waxy
way96757662wa_y
winy107034322winy
yang85626062yang
yank115423662yank
yay96948712ya_y
za1114939202za__
zag137539472za_g
zags146826682zags
zanily18310182zanily
zanza1378702zanza
zap145840692za_p
zappy21548942zappy
zaps156826892zaps
zarf166929122zarf
zas126946832za_s
zax197630632za_x
zin125643772zin_
zinc156819092zinc
zincy195413512zincy
zine137036152zine
zing145728612zing
zingy186516132zingy
zinky215314812zinky
zins135735002zins
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.0802233637.5
2DLD Change Limit298722020.93631914.5
3Display Results2022020.0633206.3
 (SQL Overall)1786912021.079165608.0
 
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.