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

187 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
sunbow114582(None) 
sunbows1236021sunbows
snow76324792s_n_ow
sundew10369692sundew
sundog837612sundog
sundown1186312sundown
sunglow1143942sunglow
unbox1438752_unbox
upbow1245612_upbow
bonbon10310073bonbon
bow87051903___bow
bubo85621913bu_bo_
bunco94616083bunco_
buncos104011593buncos
bunion83111313bunion
bunko115514513bunko_
bunkos124210323bunkos
burbot10815653burbot
burrow114610803burrow
busboy13307443busboy
downbow1653393downbow
dumbo105614063dumbo_
dumbos114111083dumbos
elbow10117703_elbow
embow1297563_embow
endow94510983_endow
enow77819873_en_ow
fogbow1544783fogbow
fungo94413133fungo_
furrow12427743furrow
fynbos1433283fynbos
gumbo104413583gumbo_
gumbos114610873gumbos
gunboat1047363gunboat
gundog935793gundog
indow95011663_indow
jumbo164311073jumbo_
jumbos17379123jumbos
junco144612203junco_
juncos15449233juncos
junior1386143junior
junto125114563junto_
juntos134110843juntos
know116115843_kn_ow
longbow1343863longbow
minnow1135583minnow
moonbow1443873moonbow
mungo84916053mungo_
mungos94311373mungos
now65950193__n_ow
outbox1537463outbox
outrow9311183outrow
oxbow1734443_oxbow
punto75121323punto_
puntos85915793puntos
rainbow1243353rainbow
rundown1165443rundown
sabot7931783s_abot
sallow94315753sallow
sambo95118013sambo_
sambos104315193sambos
sandbox1744803sandbox
sannop837373sannop
santo56227283santo_
santol64515243santol
santos64421833santos
scow96021423s__cow
senhor93010813senhor
senior63214053senior
senor53822803sen_or
sensor63813843sensor
serow86720443s_erow
shadow1337253shadow
shnook1366343shnook
show106229193s__how
sinew84718923sin_ew
skibob1433423skibob
skybox2242293skybox
slow77729493s__low
snaw78923073s_n_aw
snob65825593s_n_ob
snobs74716153s_nobs
snog55623633s_n_og
snood64616163s_nood
snook95115573s_nook
snool55118643s_nool
snoop75317173s_noop
snoot55030143s_noot
snot44745453s_n_ot
snows84719893s_n_ows
snowy115011563s_n_owy
snub65320763snub__
snubby1344533snubby
snubs75412553snub_s
sorrow9339443sorrow
soundbox1842413soundbox
sow66554763s___ow
stow77325743s__tow
strow88920573s_trow
suable83920553suable
suably112814533suably
sub55445553su_b__
suba64926603su_b_a
subah106015213su_bah
subas74724073su_bas
subbed114116673subbed
suber74924503su_ber
sublot82315523sublot
subnet82520933subnet
suborn8310013su_born
subs66037123su_b_s
succor1036623succor
sudor6312623su_dor
suitor63311053suitor
sukkot936643sukkot
sulfo8313363sulfo_
summon1037623summon
sumo67326313su_mo_
sumos75720093su_mos
sun37149033sun___
sunback1548153sunback
sunbath1236423sunbath
sunbeam1146053sunbeam
sunbelt939233sunbelt
sunbird1044743sunbird
sunblock1643763sunblock
sunburn945133sunburn
sundae7312873sundae
sunder74019823sunder
sundews11398153sundews
sundogs947103sundogs
sundowns1285433sundowns
sundry1057943sundry
sung55832173sun__g
sunglows1244083sunglows
sunk85031813sun__k
sunken103511783sunken
sunket103721363sunket
sunlit61516103sunlit
sunn45423593sun__n
sunna55016063sun_na
sunnah9369353sunnah
sunnas63914563sunnas
sunned74216323sunned
sunns55017353sun_ns
sunny84917743sun_ny
sunray9310123sunray
sunroof1047053sunroof
sunroom947013sunroom
suns45841903sun__s
sunset63723633sunset
sunspot947163sunspot
suntan62613003suntan
sunup7313053sun_up
sunups837263sunups
sybo9714743s_ybo_
symbol1336083symbol
syncom1336093syncom
synod9610283syn_od
turbo71015043turbo_
turbos8910783turbos
turbot8914263turbot
umbo85516663_umbo_
umbos94613073_umbos
unban72114333_unban
unbar71913613_unbar
unbe65319273_unb_e
unbid83214643_unbid
unbolt83013893_unbolt
unborn83310813_unborn
unbowed132610243_unbowed
unco66021403_unco_
uncos74117033_uncos
uncoy104111413_uncoy
undo55620153_undo_
ungot61718063_ungot
union54519793_union
unmew103610073_unmew
unmown11296093_unmown
unsew83912693_unsew
unsown9328433_unsown
unto45824283_unto_
unwon84512343_unwon
upbows1384683_upbows
window1347363window
wingbow1643773wingbow
winnow1234593winnow

Search took 7 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.376475242.0
2DLD Change Limit1127161875.71619719.4
3Display Results1871870.0632968.3
 (SQL Overall)1786911876.15529031.8
 
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.