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
wand8583388(None) 
and47244171_and
band76740911band
hand86833711hand
land56337311land
rand55839571rand
sand55338471sand
wad77053891wa_d
wan66761941wan_
wands96425481wands
wane76344721wane
waned95831781waned
wank115632511wank
wans76452271wans
want76156171want
wany106432361wany
ward86542251ward
wend85330451wend
wind85533851wind
wynd116114461wynd
ad311975032_a_d
add510132362_add
aid49269072_aid
aland65526412aland
an211879082_an_
ana39559832_ana
ands57833612_ands
ane37866952_ane
ani37751182_ani
ant37270792_ant
any68440492_any
award97118042award
awed88436032awed
awn68035912awn_
awned96615952awned
awns75324432awns
awny105919302awny
bad67763152ba_d
bald76432902bald
ban58366842ban_
banda85223102banda
bands85233422bands
bandy114824182bandy
bane65250432bane
baned85436352baned
bang74837002bang
bani65334962bani
bank105835752bank
bans66555142bans
bard75648862bard
baud74928422baud
bawd105520842bawd
bend76435262bend
bind76234512bind
bland85320452bland
bond75334362bond
brand85124492brand
bund75530662bund
bwana10310242bwana
cad67456362ca_d
caid77837532caid
can57760142can_
candy115119822candy
cane66653122cane
caned85838092caned
canid85526342canid
cans65050852cans
cant66362032cant
card710245872card
dad58456162da_d
dan46859672dan_
dandy104416702dandy
dang65131542dang
dank95828242dank
dans56748152dans
eland65820392eland
end46834352_end
fad77452412fa_d
fan67158862fan_
fane75343572fane
fang85432552fang
fano75831692fano
fans76247372fans
fard85639062fard
fend84832972fend
find87532602find
fond86330952fond
fund85624982fund
gad57556652ga_d
gaed66031512gaed
gan48060132gan_
gane55145302gane
gang66031972gang
gaud67025432gaud
gland75217712gland
grand75122692grand
had77658762ha_d
haed86338582haed
hands95327382hands
handy125520872handy
hang85535552hang
hank115134142hank
hant75461592hant
hard85443502hard
hind85529752hind
hwan105716892hwan_
jane115031482jane
kana85928532kana
kane85133972kane
kind96128552kind
lad48165702la_d
laid56439142laid
lands65426902lands
lane45153332lane
lang56637382lang
lank84734452lank
lard56742002lard
laud56527722laud
lend56233672lend
mad68958712ma_d
maid75537662maid
man57465872man_
mana65341962mana
mane65052032mane
maned86634102maned
mano66536812mano
mans66354552mans
many95731862many
maud75325402maud
maund85515452maund
mend75334032mend
mind75434382mind
nan37854882nan_
nana46632902nana
nans46139402nans
nard56634452nard
pad68057322pa_d
paid75737482paid
pan58466452pan_
panda85022612panda
pandy115021172pandy
pane64950292pane
paned85437182paned
pang75336292pang
pans65855732pans
pant66061262pant
pard76441322pard
pend75934532pend
pond75530492pond
qaid146023842qaid
rad47662002ra_d
raid55243072raid
ran38266622ran_
rands65930452rands
randy95022082randy
rang56939162rang
rani46640112rani
ranid66429332ranid
rank85135532rank
rant45864682rant
rend56136572rend
rind56535602rind
rynd86414102rynd
sad47459202sa_d
said55742112said
sands65228582sands
sandy94221132sandy
sane45954342sane
saned65636272saned
sang55441232sang
sank85236832sank
sans45153362sans
sard55344242sard
send55237292send
stand65923282stand
swan76631312swan_
swang95519722swang
swank125318232swank
swans84625012swans
sward94221462sward
tad47959822ta_d
tan37167572tan_
tang56138672tang
tank85134022tank
tans46154822tans
tend56433772tend
twang94511852twang
van66246332van_
vanda94515922vanda
vane75534692vane
vaned94622422vaned
vang84926042vang
vans76236732vans
vend86626422vend
viand9511072viand
wab87051832wa_b
wabs97337232wabs
wack135330912wack
waddy135312992waddy
wade85237062wade
waded106024752waded
wadi86228172wadi
wads87343142wads
wady115324992wady
wae67556952wa_e
waes76048602waes
waff134228042waff
waft106139002waft
wag76451752wa_g
wage84834082wage
waged104822782waged
wags86140552wags
waif105836752waif
wail75238822wail
wain75840202wain
wains86930872wains
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
yald86920612yald
yang85626072yang
yank115423672yank
yard85633252yard
yaud87020082yaud
yond86122312yond
zany167316992zany

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 Limit298723190.85634897.2
3Display Results3193190.0803987.5
 (SQL Overall)1786913191.016175877.0
 
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.