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

319 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
wand8583387(None) 
and47244161_and
band76740901band
hand86833701hand
land56337301land
rand55839561rand
sand55338461sand
wad77053891wa_d
wan66761931wan_
wands96425481wands
wane76344711wane
waned95831781waned
wank115632501wank
wans76452261wans
want76156161want
wany106432351wany
ward86542251ward
wend85330451wend
wind85533851wind
wynd116114461wynd
ad311975032_a_d
add510132362_add
aid49269072_aid
aland65526412aland
an211879072_an_
ana39559822_ana
ands57833612_ands
ane37866942_ane
ani37751172_ani
ant37270782_ant
any68440482_any
award97118042award
awed88436032awed
awn68035912awn_
awned96615952awned
awns75324432awns
awny105919302awny
bad67763152ba_d
bald76432902bald
ban58366832ban_
banda85223102banda
bands85233422bands
bandy114824182bandy
bane65250422bane
baned85436352baned
bang74836992bang
bani65334952bani
bank105835742bank
bans66555132bans
bard75648862bard
baud74928422baud
bawd105520842bawd
bend76435262bend
bind76234512bind
bland85320452bland
bond75334362bond
brand85124492brand
bund75530662bund
bwana10310242bwana
cad67456362ca_d
caid77837532caid
can57760132can_
candy115119822candy
cane66653112cane
caned85838092caned
canid85526342canid
cans65050842cans
cant66362022cant
card710245872card
dad58456162da_d
dan46859662dan_
dandy104416702dandy
dang65131532dang
dank95828232dank
dans56748142dans
eland65820392eland
end46834352_end
fad77452412fa_d
fan67158852fan_
fane75343562fane
fang85432542fang
fano75831682fano
fans76247362fans
fard85639062fard
fend84832972fend
find87532602find
fond86330952fond
fund85624982fund
gad57556652ga_d
gaed66031512gaed
gan48060122gan_
gane55145292gane
gang66031962gang
gaud67025432gaud
gland75217712gland
grand75122692grand
had77658762ha_d
haed86338582haed
hands95327382hands
handy125520872handy
hang85535542hang
hank115134132hank
hant75461582hant
hard85443502hard
hind85529752hind
hwan105716892hwan_
jane115031472jane
kana85928522kana
kane85133962kane
kind96128552kind
lad48165702la_d
laid56439142laid
lands65426902lands
lane45153322lane
lang56637372lang
lank84734442lank
lard56742002lard
laud56527722laud
lend56233672lend
mad68958702ma_d
maid75537642maid
man57465852man_
mana65341942mana
mane65052012mane
maned86634092maned
mano66536792mano
mans66354532mans
many95731842many
maud75325392maud
maund85515442maund
mend75334022mend
mind75434372mind
nan37854872nan_
nana46632892nana
nans46139392nans
nard56634452nard
pad68057322pa_d
paid75737482paid
pan58466442pan_
panda85022612panda
pandy115021172pandy
pane64950282pane
paned85437182paned
pang75336282pang
pans65855722pans
pant66061252pant
pard76441322pard
pend75934532pend
pond75530492pond
qaid146023842qaid
rad47662002ra_d
raid55243072raid
ran38266612ran_
rands65930452rands
randy95022082randy
rang56939152rang
rani46640102rani
ranid66429332ranid
rank85135522rank
rant45864672rant
rend56136572rend
rind56535602rind
rynd86414102rynd
sad47459202sa_d
said55742112said
sands65228582sands
sandy94221132sandy
sane45954332sane
saned65636272saned
sang55441222sang
sank85236822sank
sans45153352sans
sard55344242sard
send55237292send
stand65923282stand
swan76631312swan_
swang95519722swang
swank125318232swank
swans84625012swans
sward94221462sward
tad47959822ta_d
tan37167562tan_
tang56138662tang
tank85134012tank
tans46154812tans
tend56433772tend
twang94511852twang
van66246322van_
vanda94515922vanda
vane75534682vane
vaned94622422vaned
vang84926032vang
vans76236722vans
vend86626422vend
viand9511072viand
wab87051832wa_b
wabs97337232wabs
wack135330912wack
waddy135312992waddy
wade85237062wade
waded106024752waded
wadi86228172wadi
wads87343142wads
wady115324992wady
wae67556952wa_e
waes76048602waes
waff134228042waff
waft106139002waft
wag76451752wa_g
wage84834082wage
waged104822782waged
wags86140552wags
waif105836752waif
wail75238822wail
wain75840192wain
wains86930862wains
wair75830052wair
wait75553692wait
wake114935702wake
waked135626752waked
wale74546432wale
waled94330992waled
walk115625612walk
wall76236102wall
waly105830902waly
wame95035482wame
wander104423712wander
wandle105316662wandle
wanes85040882wanes
waney115120322waney
wanked144517152wanked
wanks126124482wanks
wanly115118022wanly
wanned104318012wanned
wanted104319722wanted
wants87932212wants
wap86553372wa_p
waps96642082waps
war67262422wa_r
wards97734402wards
ware76254722ware
wared96339872wared
wark115737772wark
warm95935672warm
warn75239322warn
warned104018912warned
warns87231002warns
warp95635002warp
wars78659802wars
wart77866082wart
wary106740012wary
was68767562wa_s
wash106033812wash
wasp95626852wasp
wast75655852wast
wat67378922wa_t
wats77555882wats
watt75545412watt
wauk115220592wauk
waul76927312waul
waur76819902waur
wave105234732wave
waved125223582waved
wavy136620472wavy
waw97046382wa_w
wawl105321942wawl
waws106834902waws
wax137041182wa_x
waxed166018482waxed
waxy175918202waxy
way96757662wa_y
ways107737952ways
weald95615022weald
wean75734352wean_
weaned103816152weaned
weans85326742weans
wed75843622w_ed
weed85637512weed
weld84727732weld
wen66249602wen_
wends95822812wends
wens76337932wens
went76051872went
whang124813382whang
whid115418872whid
wild85126512wild
win66456292win_
winds95425602winds
windy126118102windy
wine74953422wine
wined94434182wined
wing86339222wing
wink116435022wink
wino75933612wino
wins75949172wins
winy107034322winy
woad85523942woad
woald94813072woald
wold85429072wold
won66252062won_
wonk116125302wonk
wons74942042wons
wont75842502wont
wood85329382wood
word89832002word
wound94414212wound
wrang94716112wrang
wud76227152w_ud
wyn95921442wyn_
wynds126310372wynds
wynn105811292wynn
wyns105717032wyns
yald86920602yald
yang85626062yang
yank115423662yank
yard85633252yard
yaud87020082yaud
yond86122312yond
zany167316982zany

Search took 1 second 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.0762351197.4
2DLD Change Limit298723190.75039829.3
3Display Results3193190.0764197.4
 (SQL Overall)1786913190.902198105.3
 
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.