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

138 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
gowds10581404(None) 
goads77022851goads
gods65438041go_ds
golds75421311golds
goods75124481goods
gowd96519981gowd_
gowks136011951gowks
gowns95115101gowns
bawds116115492bawds
bods76244712bo_ds
bolds85825282bolds
bonds86126842bonds
bowls106121432bowls
bows96242862bow_s
cods76848102co_ds
coeds85920162coeds
colds85726972colds
cords86030622cords
cowls106922212cowls
cows97046642cow_s
crowds124910762crowds
dowdy136112542dowdy
downs94918572downs
dows85941052dow_s
folds95221692folds
fonds95824822fonds
foods95924162foods
fords95328182fords
fowls115518892fowls
gads67843382g_ads
gauds75717722gauds
gawks136811632gawks
gawps115911012gawps
geds66730812g_eds
gelds75118342gelds
geoids8369842geoids
gids65933732g_ids
gilds75417522gilds
girds74816992girds
glads75620612glads
gleds75417892gleds
glows95518032glow_s
goad66830982goad_
goals65521292goals
goas55239942go_as
goats65527302goats
gobos86219382gobos
gobs76935572go_bs
god57449792go_d_
goers65520252goers
goes55644092go_es
gogos77516522gogos
gold65430162gold_
golfs95616102golfs
gonads84511732gonads
gongs74921612gongs
good66531802good_
goody105620392goody
goofs94821002goofs
gooks105422882gooks
goons65326772goons
goops86620962goops
goos57644912go_os
gores65740372gores
gorms85619592gorms
gorps85316992gorps
gos47155132go__s
goths96513002goths
gourds8108252gourds
gouts64826172gouts
gowan95415742gowan
gowans105512292gowans
gowk125516472gow_k
gown85724072gow_n
goxes135018262goxes
goys86328412go_ys
grads75625752grads
grids75321392grids
growls104711112growls
grows95523922grow_s
guids75516152guids
hods87239862ho_ds
holds94623242holds
hoods95124082hoods
howdy155711412howdy
howes114730262howes
howfs144814502howfs
howks155016852howks
howls116219222howls
hows106345602how_s
jowls156214522jowls
jows146632092jow_s
loads65323372loads
loids66220702loids
lords64923502lords
lowes85732462lowes
lows75843012low_s
mods77945052mo_ds
molds85324832molds
moods85224622moods
mows96340832mow_s
nods55838222no_ds
nows75738232now_s
nowts86915862nowts
odds68919922_odds
ods47546212_o_ds
olds55926572_olds
ouds56430102_ouds
owes75137102_owes
owls76022932_owls
owns76819582_owns
pods76540152po_ds
ponds85323402ponds
poods85124752poods
pows95537662pow_s
roads66523622roads
rods56442062ro_ds
roods65125282roods
rowdy125711532rowdy
rows75941752row_s
sods54940212so_ds
sords64527802sords
sows75342492sow_s
toads65621072toads
tods56141842to_ds
towns86018882towns
tows78545552tow_s
voids95414672voids
vows106626942vow_s
woads94818442woads
wolds95420182wolds
woods95723032woods
words95425072words
wows104633492wow_s
yods86531182yo_ds
yowes114926372yowes
yowls115715432yowls
yows106433122yow_s

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.1101624463.6
2DLD Change Limit538001381.56334421.0
3Display Results1381380.0463000.0
 (SQL Overall)1786911381.719103950.6
 
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.