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

298 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
wany10643235(None) 
any68440481_any
awny105919301awny
many95731841many
wady115324991wady
waly105830901waly
wan66761931wan_
wand85833871wand
wane76344711wane
waney115120321waney
wank115632501wank
wanly115118021wanly
wans76452261wans
want76156161want
wary106740011wary
wavy136620471wavy
waxy175918201waxy
way96757661wa_y
winy107034321winy
zany167316981zany
aby810238062_aby
an211879072_an_
ana39559822_ana
and47244162_and
ane37866942_ane
ani37751172_ani
ant37270782_ant
away108024222away
awn68035912awn_
awns75324432awns
awry107619682awry
ay511773892_a_y
baby116723672baby
ban58366832ban_
band76740902band
bandy114824182bandy
bane65250422bane
bang74836992bang
bani65334952bani
bank105835742bank
bans66555132bans
banty106624002banty
barny105821732barny
bay89661642ba_y
bony96732082bony
bwana10310242bwana
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
gowany13457492gowany
hand86833702hand
handy125520872handy
hang85535542hang
hank115134132hank
hanky155418292hanky
hant75461582hant
hay97358772ha_y
hazy1918119192hazy
hwan105716892hwan_
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
swamy136714402swamy
swan76631312swan_
swang95519722swang
swank125318232swank
swanky16447972swanky
swanny12336822swanny
swans84625012swans
sway107128232swa_y
tan37167562tan_
tang56138662tang
tangy94519932tangy
tank85134012tank
tans46154812tans
tansy84514932tansy
tawny114713652tawny
tiny76134632tiny
tony75635152tony
twang94511852twang
twangy13386982twangy
twanky16445772twanky
twiny116012812twiny
van66246322van_
vane75534682vane
vang84926032vang
vans76236722vans
vary105226062vary
viny106025952viny
wab87051832wa_b
wabs97337232wabs
wack135330912wack
wacky174714932wacky
wad77053892wa_d
waddy135312992waddy
wade85237062wade
wadi86228172wadi
wads87343142wads
wae67556952wa_e
waes76048602waes
waff134228042waff
waft106139002waft
wag76451752wa_g
wage84834082wage
wags86140552wags
waif105836742waif
wail75238822wail
wain75840192wain
wains86930862wains
wair75830052wair
wait75553692wait
wake114935702wake
wale74546432wale
walk115625612walk
wall76236102wall
wally114625092wally
wame95035482wame
wands96425482wands
waned95831782waned
wanes85040882wanes
wanks126124482wanks
wants87932212wants
wap86553372wa_p
waps96642082waps
war67262422wa_r
ward86542252ward
ware76254722ware
wark115737772wark
warm95935672warm
warn75239322warn
warns87231002warns
warp95635002warp
wars78659802wars
wart77866082wart
warty119323822warty
was68767562wa_s
wash106033812wash
washy145911842washy
wasp95626852wasp
waspy135410992waspy
wast75655852wast
wat67378922wa_t
wats77555882wats
watt75545412watt
wauk115220592wauk
waul76927312waul
waur76819902waur
wave105234732wave
wavey145115542wavey
waw97046382wa_w
wawl105321942wawl
waws106834902waws
wax137041182wa_x
ways107737952ways
wean75734352wean_
weans85326742weans
weary115620612weary
weeny115316162weeny
wen66249602wen_
wend85330452wend
wenny114412462wenny
wens76337932wens
went76051872went
whang124813382whang
whey135018712whey
whiny144915572whiny
why126920012w_hy
wily106428812wily
win66456292win_
wind85533852wind
windy126118102windy
wine74953422wine
winey115325432winey
wing86339222wing
wingy126521032wingy
wink116435022wink
wino75933612wino
wins75949172wins
wiry106422832wiry
won66252062won_
wonk116125302wonk
wonky154011772wonky
wons74942042wons
wont75842502wont
wrang94716112wrang
wry96524702w_ry
wyn95921442wyn_
wynd116114462wynd
wynn105811292wynn
wyns105717032wyns
yang85626062yang
yank115423662yank
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.1731032896.0
2DLD Change Limit298722980.96630923.4
3Display Results2982980.0634730.2
 (SQL Overall)1786912981.202148661.4
 
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.