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

146 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
goose6592590(None) 
goos57644911goos_
goosed86817031goosed
gooses75723051gooses
goosey105913511goosey
goosy96018881goosy
gorse65926811gorse
loose56627681loose
moose76327191moose
noose55624061noose
roose56127091roose
arose55832082arose
boos67955032boos_
boost75132472boost
booze164718912booze
bouse75931852bouse
bowse105420632bowse
brose75227032brose
choose115116142choose
chose105925402chose
close76425222close
comose105016842comose
cooee74531022cooee
coos67456492coos_
copse95623922copse
corse75036182corse
dose56442432_dose
douse66329722douse
dowse96020812dowse
erose55727272erose
fosse86119462fosse
geese64316002geese
geode7412592geode
ghost96318762ghost
globe84917012globe
globose1035542globose
gloss64319622gloss
glost65422932glost
glove94516292glove
gloze154815982gloze
gnome84213952gnome
gnoses76515162gnoses
goas55239942goas_
goboes95914442goboes
gobos86219382gobos_
gobs76935572gobs_
gods65438042gods_
goes55644092goes_
gogos77516522gogos_
golosh1036462golosh
goloshe1134722goloshe
gone55639042g_one
goo47754772goo__
goober93911742goober
good66531802goo_d
goodie83613992goodie
goods75124482goods
goody105620392goody
gooey95522862gooey
goof85436872goo_f
goofed114911382goofed
goofs94821002goofs
goofy124915622goofy
gooier73516212gooier
gook96429602goo_k
gooks105422882gooks
gooky135818032gooky
goon57236172goo_n
gooney106612312gooney
goonie73615562goonie
goons65326772goons
goony95519782goony
goop75829482goo_p
goops86620962goops
goopy115816622goopy
goosier83512562goosier
gore55744962g_ore
gores65740372gores
gorge76423892gorge
gorses74723292gorses
gorsy95915782gorsy
gos47155132g_os_
gosh86123422g_osh
gouge78220062gouge
goxes135018262goxes
goys86328412goys_
groove10438872groove
grope84821612grope
gross65421692gross
grosz154814092grosz
grosze16457732grosze
grouse74315022grouse
grove95219332grove
guise64717712guise
gyrose105310252gyrose
hoise85224772hoise
horse86132652horse
hose76547242_hose
house89131422house
jocose1537102jocose
looie55624242looie
loos49051122loos_
loosed75520892loosed
loosen66615962loosen
looser65219942looser
looses67328242looses
lose45144582_lose
louse56131012louse
lowse87219902lowse
moos66051302moos_
morose85116242morose
morse76032702morse
mouse77133002mouse
nodose738882nodose
noise55723732noise
noosed75018012noosed
nooser65517822nooser
nooses65623642nooses
nose46739362_nose
ooze136420602_ooze
ose38147342__ose
owse76321622_owse
poise75127892poise
poos65949112poos_
poove104514302poove
porose84818742porose
pose66441732_pose
posse74722272posse
prose75835122prose
roosed75621592roosed
rooser63921882rooser
rooses65526232rooses
roost55730932roost
rose46148902_rose
rouse56634702rouse
souse56530772souse
those85218142those
torose64317692torose
torse55833332torse
touse55430672touse
whose114914532whose
woos76238802woos_
woosh113710732woosh
worse86525262worse
youse85322232youse
zoos135828802zoos_

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 Filter178691538000.313570897.8
2DLD Change Limit538001461.48336277.8
3Display Results1461460.0502920.0
 (SQL Overall)1786911461.84696799.0
 
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.