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

245 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
sorrow933944(None) 
borrow114310721borrow
morrow113510091morrow
sorrows10278401sorrows
arrow83414882_arrow
barrow114512762barrow
borrows12349252borrows
burrow114610802burrow
cornrow1245602cornrow
farrow12309972farrow
furrow12427742furrow
harrow122610772harrow
horror988722horror
marrow112812602marrow
morro73216952morro_
morros83714672morros
morrows12318722morrows
narrow9269142narrow
serow86720442s_erow
sordor7310212sordor
sorgo64719722sorgo_
sorgos74514662sorgos
sorrel6413542sorrel
sorrowed1264832sorrowed
sorrower1165032sorrower
sorry84618252sorr_y
sparrow1234262sparrow
strow88920572s_trow
yarrow12287932yarrow
arrows92813483_arrows
arrowy12288273_arrowy
barlow112911423barlow
barrows123411683barrows
boron76727143bo_ron
borrowed1465043borrowed
borrower1384833borrower
borzoi1736623borzoi
bowwow1334463bowwow
brow97228443__brow
burro75018493burro_
burros85114993burros
burrows12399093burrows
carrom10513403carrom
carrot8423123carrot
cordon95017293cordon
cornrows1345313cornrows
corral83616253corral
corrie83621213corrie
corrode101310573corrode
corrody13136143corrody
crow96428133__crow
dobro84412213dobro_
dobros93910233dobros
dorr56627723dorr__
dorrs65520593dorr_s
error53712233_error
escrow1135913escrow
farrows13259783farrows
fogbow1544783fogbow
follow124010353follow
fordo97218653fordo_
forgo94418333forgo_
forgot104318133forgot
formol112910333formol
forrit91916623forrit
frow106425053__frow
furrows13327793furrows
furrowy16384473furrowy
garron73113493garron
gorgon8310243gorgon
grow86127303__grow
harrows132611033harrows
hollow124212663hollow
horrid10311553horrid
horrors1078693horrors
hotrod1048793hotrod
karroo10410013karroo
kotow12528703ko_tow
kouroi1036513kouroi
kouros1039183kouros
kowtow1643463kowtow
lorry86315663lorr_y
lowbrow1543273lowbrow
marron83717543marron
marrows122911813marrows
marrowy15236083marrowy
mirror848003mirror
morion86217733morion
moron76925423mo_ron
morrion959003morrion
morris83814723morris
narrows10258843narrows
nohow1137293no_how
ordo54622353_ordo_
ordos65216203_ordos
orlon5415003_orlon
orlop7410903_orlop
orra46120723_orr_a
orris54516553_orris
orzo134516783_orzo_
orzos143311253_orzos
outrow9311173outrow
oxbow1734443_oxbow
parrot8320663parrot
perron83216623perron
pogrom1138593pogrom
porno75120653porno_
pornos85015253pornos
powwow1342833powwow
prow97030383__prow
pyrrol1136273pyrrol
regrow10309883regrow
row67453673___row
safrol937283safrol
sallow94315753sallow
sargo65424413sargo_
sargos74318273sargos
sarod65325873s_arod
saros55238063s_aros
sartor6313873sartor
schrod1247883schrod
scow96021423s__cow
screw109318533s_crew
scrod85115063s_crod
scroop10299773scroop
sermon8413553sermon
serows96016393s_erows
serry84824123serr_y
servo84516683servo_
servos93812723servos
shadow1337253shadow
show106229183s__how
shrew119720163s_hrew
sirra54416323sirr_a
sirrah9379753sirrah
sirras63814863sirras
sirree64017333sirree
slow77729493s__low
snow76324793s__now
soar46838673soar__
soared74324293soared
soarer64522243soarer
soars54732513soar_s
socko115215113socko_
sodom8814903so_dom
soiree62919483soiree
sokol94612283so_kol
soldo67116563soldo_
solion6616383solion
solo45538943so_lo_
solon55026133so_lon
solos54830793so_los
somehow1543663somehow
sook84933393so__ok
soon46240503so__on
soot45761053so__ot
sopor74016493so_por
sopors85215193sopors
sora45746913so_r_a
soras55041013so_ras
sorb68333043so_r_b
sorbed94916513sorbed
sorbet83924073sorbet
sorbic10310383sorbic
sorbose938983sorbose
sorbs75022103so_rbs
sord56237203so_r_d
sordid83411153sordid
sordors839983sordors
sords64527803so_rds
sore47059533so_r_e
sored66141783so_red
sorel56231443so_rel
sorels63921163sorels
sorely94618003sorely
sorer56236573so_rer
sores55454283so_res
sorest65027993sorest
sorgho10348713sorgho
sorghos11327603sorghos
sori46039833so_r_i
soring74731883soring
sorn46641063so_r_n
sorned74820043sorned
sorner64720383sorner
sorns55028413so_rns
sororal7310653sororal
sorrels7310713sorrels
sorrier72313723sorrier
sorrily1039823sorrily
sorrowers1274753sorrowers
sorrowful1551593sorrowful
sorrowing1344873sorrowing
sort46264813so_r_t
sorta57125413so_rta
sorted74523713sorted
sorter64425083sorter
sortie63621983sortie
sorts54536663so_rts
sorus54527583so_rus
sotol54917643so_tol
sour45935893sour__
source8410673source
soured74921863soured
sourer63620213sourer
sourly93612203sourly
sours55230503sour_s
soursop943033soursop
sovran937153sovran
sow66554763s___ow
sparrows1344803sparrows
sporran936743sporran
sterol6613323sterol
stow77325743s__tow
straw813321293s_traw
strew89220653s_trew
strook10410303strook
strop77422243s_trop
strown96812093s_trown
strows96718273s_trows
stroy87720393s_troy
sunbow1145823sunbow
surra55521343surr_a
surras65919533surras
surrey94414573surrey
terror63811723terror
throw118719733_throw
tomorrow1342083tomorrow
torero6313203torero_
toreros7311343toreros
toro48045683to_ro_
toros54336193to_ros
torot56139943to_rot
torpor839193torpor
torr45630903torr__
torrid7311853torrid
torrs53923563torr_s
torso56922143torso_
torsos64815733torsos
trow78031423__trow
upgrow1234273upgrow
vrow105817473__vrow
worrit92313313worrit
worry116114333worr_y
yarrows13277853yarrows

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.1401276364.3
2DLD Change Limit1127162456.15618309.9
3Display Results2452450.0932634.4
 (SQL Overall)1786912456.38927968.5
 
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.