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

154 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
ouch9572463(None) 
couch125320111couch
mouch124715801mouch
much115224031much
ouph95618371ouph
pouch124617081pouch
such96424811such
touch106519391touch
vouch134611901vouch
yuch125818531yuch
arch98628442arch
avouch1434832avouch
bach116131392bach
botch126717452botch
bough115719312bough
buck125129902buck
bunch125118602bunch
bush96630712bush
butch125416542butch
coach125919452coach
conch124620072conch
cooch124916832cooch
cough115819642cough
couth106122482couth
crouch133910202crouch
culch124512832culch
curch124415412curch
cutch125116192cutch
douce85518422douce
douche124613222douche
dough105217382dough
duce76933502duce
duchy144310872duchy
duci76422622duci
duck115929172duck
duct75735462duct
duh77930382du_h
dunch115316262dunch
dutch114713822dutch
each95530582each
etch95419142etch
fuci95720312fuci
fuck134924632fuck
grouch12318472grouch
guck114922532guck
gulch113810602gulch
gush85424002gush
heuch135312332heuch
hooch135813702hooch
hotch136214722hotch
huck135927632huck
huh96432012hu_h
hunch136416212hunch
hunh106323732hunh
hush105224112hush
hutch135414092hutch
ich86227742_ich
inch95420822inch
itch95619172itch
juco134716202juco
lech96825442lech
lich96230842lich
loach105116362loach
loch95527132loch
louche115212662louche
lough95118482lough
luce65132572luce
luck105329822luck
lunch104917242lunch
lurch104814632lurch
lush75327692lush
lych126015762lych
mach116134472mach
mooch125313612mooch
mouth105420292mouth
mucho125013442mucho
muck125727852muck
mulch124012972mulch
munch124917102munch
mush94929122mush
mutch125016172mutch
notch105613322notch
nucha10229792nucha
oath76132152oath
oca56731732o_ca
odah87018932odah
oh57447002o__h
okeh114615322okeh
once65423082once
ooh67637092o_oh
opah96218402opah
orach105219232orach
orc57034922orc_
orca65522772orca
orcs67025432orcs
ouched124316932ouched
ouches114322182ouches
oud47439072ou_d
ouds56430102ouds
ought95221532ought
ounce77019932ounce
ouphe104413262ouphe
ouphs104311272ouphs
our36042892ou_r
ours47237562ours
oust46747442oust
out38072152ou_t
outs45746962outs
ouzo133516932ouzo
pech116125452pech
poach124917862poach
pooch124815302pooch
porch125918622porch
pouchy16538662pouchy
puce85127882puce
puck124927942puck
pugh106619232pugh
punch125118422punch
push95526622push
rich97025542rich
roach105717002roach
rotch105815932rotch
rouche114714312rouche
rough97819432rough
routh86423072routh
ruche104216762ruche
ruck104728332ruck
rush76628182rush
ruth76825992ruth
sauch104918772sauch
slouch11438522slouch
sough95320462sough
south85223572south
suck106131732suck
sugh86423442sugh
tach96132752tach
tech95925442tech
teuch105214852teuch
torch107420932torch
touche114916172touche
touchy145010502touchy
tough97321982tough
tuck104626572tuck
tush74523902tush
ugh76520682_ugh
uh57429852_u_h
vugh117115722vugh
wich125724742wich
wych154011882wych
yech127220532yech
youth115315042youth
yuca95716722yuca
yucch15417432yucch
yuck136423532yuck

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.1401276364.3
2DLD Change Limit298721541.65618038.6
3Display Results1541540.0463347.8
 (SQL Overall)1786911541.84297009.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.