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

243 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
sculch1322621(None) 
culch124512831_culch
scultch1483541scultch
scutch13247081scutch
cultch13385952_cultch
curch124415412_curch
cutch125116192_cutch
gulch113810602_gulch
mulch124012972_mulch
sauch104918772sau_ch
scooch13228122scooch
scorch13198092scorch
scotch13207512scotch
scrunch1444032scrunch
sculches15176272sculches
sculk115112462scul_k
sculks123610262sculks
scull75315762scul_l
sculls84613882sculls
sculp95314842scul_p
sculps104611752sculps
sculpt104412692sculpt
smutch13205842smutch
squelch2152942squelch
such96424812s_u_ch
sulci7615052s_ulci
aculei839793aculei
belch124415503_belch
brunch13329353brunch
bunch125118603_bunch
butch125416543_butch
catch125120373_catch
church1636483church
cinch124516243_cinch
clach124617823_clach
cluck134914893_cluck
clutch13367753clutch
coach125919453_coach
conch124620073_conch
cooch124916833_cooch
couch125320113_couch
crunch13349503crunch
crutch13408243crutch
cuish10313173_cuish
culches143710743_culches
culet76040343_culet
culex144613933_culex
cull65929643_cul_l
culls75425813_culls
cully105520463_cully
culm85822383_cul_m
culms95314193_culms
culpa93610963_culpa
cult66541153_cul_t
culti76317253_culti
cults75022553_cults
dunch115316263_dunch
dutch114713823_dutch
filch134813323_filch
glunch1255353glunch
grutch12285563grutch
haunch14377343haunch
heuch135312333heu_ch
hunch136416213_hunch
hutch135414093_hutch
launch11368063launch
lunch104917243_lunch
lurch104814633_lurch
milch124413373_milch
mouch124715803mou_ch
much115224033_mu_ch
mulct93820083_mulct
munch124917103_munch
mutch125016173_mutch
nautch1144813nautch
ocular8610133ocular
oculi72010793ocul_i
oculus8178393oculus
oscula837293oscul_a
oscular937933oscular
oscule838193oscul_e
oscules938123oscules
osculum1143833osculum
ouch95724633_ou_ch
paunch13369853paunch
pouch124617083pou_ch
punch125118423_punch
raunch11358433raunch
samech13277033samech
sauce75121653sau_ce
sauchs115112233sau_chs
saucy104615163sau_cy
saugh95318403sau_gh
saul45836523saul__
sauls55128123saul_s
sault55834963saul_t
saults65816173saults
scalar83612433scalar
scald84818123scal_d
scalds94813693scalds
scale74629143scal_e
scaled94822443scaled
scaler84321603scaler
scales84529313scales
scall74420373scal_l
scalls84218203scalls
scalp95217983scal_p
scalps104315233scalps
scaly104718723scal_y
scarce104013633scarce
scarph13429603scarph
schlep1347093schlep
schlock18235873schlock
schlub1355003schlub
schul102510413schul__
schuln11256233schul_n
schuls11299853schul_s
scilla8310943scilla
scold85414863scol_d
scolds95011233scolds
scolex1538243scolex
sconce104711723sconce
scootch1434453scootch
scouth115011153scouth
scraich1436763scraich
scratch1446013scratch
screech1435213screech
scrooch1444953scrooch
scrunchy1852383scrunchy
scuba94211593scu_ba
scubas103710223scubas
scud76221283scu__d
scudi85112163scu_di
scudo85412213scu_do
scuds85116243scu_ds
scuff133914893scu_ff
scuffs14419053scuffs
sculked14307183sculked
sculker13318323sculker
sculled102911693sculled
sculler99812153sculler
sculped12398253sculped
sculpin11236653sculpin
sculpts11377063sculpts
scultches1664293scultches
scum85924523scu__m
scummy15265223scummy
scums95017423scu_ms
scup84822383scu__p
scups95316653scu_ps
scurf104719323scu_rf
scurfs113210813scurfs
scurfy14338763scurfy
scurry11419583scurry
scurvy14386103scurvy
scut65835543scu__t
scuta75815753scu_ta
scutched16186893scutched
scutcher15176963scutcher
scutches15168883scutches
scute75520943scu_te
scutes85219193scutes
scuts74522523scu_ts
scutum1036363scutum
scuzz1537573scu_zz
scuzzy1933083scuzzy
search113312423search
secular92211533secular
selah8319613s_elah
sheuch14267043sheuch
shuck144314533shu_ck
shul75823153shul__
shuln84713113shul_n
shuls85319713shul_s
shush113812543shu_sh
sketch1535353sketch
skulk8479623skul_k
skulks9427243skulks
skull94812033skul_l
skulls10429643skulls
slatch114510533slatch
slouch11438523slouch
sluice849513sluice
sluicy1166483sluicy
slush85316573slu_sh
smirch1356463smirch
smooch13266803smooch
smush104410583smu_sh
smutchy17193153smutchy
snatch114310603snatch
snitch11357943snitch
snuck114411913snu_ck
sough95320463sou_gh
soul46435713soul__
souled75419823souled
souls55127363soul_s
source8410673source
south85223573sou_th
speech1347563speech
spilth11469733spilth
squash1846833squash
squelchy2591973squelchy
squinch2134833squinch
squish1838573squish
squush1833993squush
stanch113812373stanch
starch113013203starch
staunch1244273staunch
stench114111163stench
stich104117923s_tich
stitch11419103stitch
stucco1044253stucco
stuck114515773stu_ck
stull54916273stul_l
stulls63912983stulls
subah106015213s_ubah
succah1336643succah
suck106131733s_u_ck
sugh86423443s_u_gh
sulcal8311273s_ulcal
sulcus8410493s_ulcus
sulfa8313923s_ulfa
sulfo8313363s_ulfo
sulk85326653s_ul_k
sulks94818463s_ulks
sulky124715363s_ulky
sully84622893s_ully
sulpha1135403s_ulpha
sulu45128423s_ul_u
sulus54821883s_ulus
sumach135310113sumach
surah86823253s_urah
swatch14549283swatch
switch14458913switch
sylph1347793s_ylph
synch135011793s_ynch
teuch105214853teu_ch
touch106519393tou_ch
vouch134611903vou_ch
welch134411493_welch
yucch15417433_yucch
yuch125818533_yu_ch
zilch19438123_zilch

Search took 10 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 Limit1127162439.00012524.0
3Display Results2432430.0763197.4
 (SQL Overall)1786912439.21619389.2
 
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.