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 “sundog” with Change Limit: [1] [2] [3]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

262 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
sundog83761(None) 
gundog935791gundog
sundogs947101sundogs
bandog1038722bandog
gundogs1034602gundogs
sandhog1275452sandhog
seadog838742seadog
snog55623632s_n_og
sudor6312622su_dor
sunbow1145822sunbow
sundae7312872sundae
sunder74019822sunder
sundew10369692sundew
sundown1186312sundown
sundry1057942sundry
sung55832172sun__g
undo55620152_undo_
asunder856223asunder
bandogs1138363bandogs
bulldog1174253bulldog
bunco94616083bunco_
buncos104011593buncos
bund75530663bund__
bundle94315573bundle
bunds85523543bund_s
bundt85824853bund_t
bundts95010843bundts
bung75730633bun__g
bunion83111313bunion
bunko115514513bunko_
bunkos124210323bunkos
candor94516423candor
cantdog1134573cantdog
condo85322593condo_
condom114215363condom
condor94616963condor
condos94322333condos
coydog1335133coydog
cundum1136513cundum
dog57449753___dog
dung66328433dun__g
duolog835803duolog
endow94510983_endow
fandom122110893fandom
fogdog1234223fogdog
fund85624983fund__
funded114413893funded
funder104016083funder
fundi96814913fund_i
fundic12389083fundic
funding124113663funding
funds94119253fund_s
fundus10429173fundus
fungo94413133fungo_
guidon837373guidon
hangdog1343133hangdog
hotdog1134793hotdog
hung86126353hun__g
incog838253_incog
indol63714873_indol
indow95011663_indow
judo125315303ju_do_
judos134711733ju_dos
junco144612203junco_
juncos15449233juncos
junior1386143junior
junto125114563junto_
juntos134110843juntos
kendo105113223kendo_
kendos114510663kendos
kudo96115103ku_do_
kudos105011253ku_dos
lapdog1034443lapdog
lung55732493lun__g
mondo85721233mondo_
mondos95217333mondos
mungo84916053mungo_
mungos94311373mungos
nog46847313__n_og
outdo6312703outdo_
pundit92914183pundit
pung75429633pun__g
punto75121323punto_
puntos85915793puntos
putlog965553putlog
quahog1944103quahog
quandong1942943quandong
quohog1942503quohog
random92513553random
rondo65218373rondo_
rondos74616723rondos
rundle73214233rundle
rundown1165443rundown
rung56429973run__g
sand55338463sand__
sandal73317283sandal
sandbag11106243sandbag
sandbox1744803sandbox
sanded84920613sanded
sander74828533sander
sandhi1038193sandhi
sandhogs1365483sandhogs
sanding93520603sanding
sandlot8311693sandlot
sands65228583sand_s
sandy94221133sand_y
sang55441223san__g
saning75127643saning
sannop837373sannop
santo56227283santo_
santol64515243santol
santos64421833santos
sawlog1035793sawlog
scudo85412213scudo_
seadogs958643seadogs
seldom939403seldom
send55237293send__
sendal73314993sendal
sended85121233sended
sender73824413sender
sending94221373sending
sendoff1446233sendoff
sends65528243send_s
sendup9106343sendup
senhor93010803senhor
senior63214043senior
senor53822793sen_or
sensor63813833sensor
shadow1337253shadow
shindig12244213shindig
shnook1366333shnook
shog86025133s__hog
sing57544173sin__g
skidoo1136093skidoo
slog56728273s__log
slung65117833slun__g
smog76317413s__mog
snag55827873s_n_ag
snob65825593s_n_ob
snogs66017493s_n_ogs
snood64616163s_nood
snook95115573s_nook
snool55118643s_nool
snoop75317173s_noop
snoot55030133s_noot
snot44745443s_n_ot
snow76324793s_n_ow
snug55218693s_n_ug
sodom8814903s_odom
soldo67116563soldo_
sonde64622833sond_e
sonder73623523sonder
sondes74922873sondes
song55133673son__g
sordor7310213sordor
sound64420023sound__
soundbox1842413soundbox
sounded93214463sounded
sounder83315383sounder
sounding102712873sounding
soundly1136683soundly
sounds74616183sound_s
spado83713703spado_
stung65417153stun__g
subdeb1137523subdeb
subdue9128493subdue
sublot82315523sublot
succor1036623succor
sudd64719773su_d_d
sudden83310833sudden
sudds75513593su_dds
sudors7311093su_dors
suds56135293su_d_s
sudsy95010683su_dsy
sued56537933sued__
suede64419753sued_e
sueded84014633sueded
suedes73918113suedes
sueding92613753sueding
suing65026363su_ing
suitor63311053suitor
sukkot936633sukkot
suldan72611043suldan
sulfo8313363sulfo_
summon1037623summon
sumo67326313su_mo_
sumos75720093su_mos
sun37149033sun___
sunbows1236023sunbows
sundaes8313093sundaes
sundeck1445273sundeck
sunders84120053sunders
sundews11398153sundews
sundial859863sundial
sundowns1285433sundowns
sundrops1145823sundrops
sunglow1143943sunglow
sunk85031813sun__k
sunken103511783sunken
sunket103721363sunket
sunlit61516103sunlit
sunn45423593sun__n
sunna55016063sun_na
sunnah9369353sunnah
sunnas63914563sunnas
sunned74216323sunned
sunning83715673sunning
sunns55017353sun_ns
sunny84917743sun_ny
sunray9310123sunray
sunroof1047053sunroof
sunroom947013sunroom
suns45841903sun__s
sunset63723633sunset
sunspot947163sunspot
suntan62613003suntan
sunup7313053sun_up
sunups837263sunups
surd56433813surd__
surds65624663surd_s
swung95610563swun__g
synagog1243623synagog
syncom1336093syncom
syndet10311963syndet
syndic1237303syndic
synod9610283syn_od
synods1077953synods
tendon7312033tendon
tondo69718683tondo_
tondos75115913tondos
tundra736423tundra
tung55328163tun__g
tuning74016843tuning
udo49027303_u_do_
udon56017743_u_don
udos56619903_u_dos
unbox1438753_unbox
unclog956603_unclog
unco66021403_unco_
uncos74117033_uncos
uncoy104111413_uncoy
unde55825483_und_e
undee65327273_undee
under64624213_under
undid72415363_undid
undock1337703_undock
undoer73113043_undoer
undoes73917403_undoes
undoing9312243_undoing
undone7914253_undone
undue66715553_undue
undy85015163_und_y
ungot61718063_ungot
union54519793_union
unpeg8309363_unpeg
unrig61711413_unrig
unto45824283_unto_
unwon84512343_unwon
updo76712883_updo_
updos8389513_updos
vendor10359803vendor
window1347363window

Search took 6 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 Filter1786911127160.1401276364.3
2DLD Change Limit1127162625.23621527.1
3Display Results2622620.0763447.4
 (SQL Overall)1786912625.45232775.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.