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

135 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
gumweed143394(None) 
gumweeds1542381gumweeds
agueweed1342172agueweed
burweed1347822burweed
cudweed1444212cudweed
gulfweed1641952gulfweed
gummed123811662gum_med
gumwood14114042gumwood
sumpweed1643722sumpweed
agueweeds1441943agueweeds
blueweed1444043blueweed
bugseed1136173bugseed
bullweed1444753bullweed
bumbled144113043bumbled
bummed134211723bum_med
bumped134414003bum_ped
bumpered1536003bumpered
burseed1049503burseed
burweeds1434103burweeds
cudweeds1542413cudweeds
cumbered15157963cumbered
duckweed1943023duckweed
dumbed124012083dum_bed
dummied13346723dummied
dumped123814493dum_ped
dyeweed1543203dyeweed
emceed1136283_emceed
fumbled153710493fumbled
fumed116118823fum__ed
gambled134112163gambled
gamed95126393gam__ed
gammed124216163gam_med
gaumed104610323gaum__ed
gawked15468763g_awked
gawped13509073g_awped
geed65435503g___eed
gemmed12329573gem_med
gimleted1243973gimleted
gimped123911473gim_ped
glaceed1136203glaceed
gleed75320573g__leed
glowed114913833glow_ed
glowered1345753glowered
gnawed11427833gnaw_ed
goateed9307063goateed
gombeen1243733gombeen
gowned114410133g_owned
greed75125693g__reed
growled12278173growled
grumbled14256753grumbled
grummeted1552153grummeted
grumped13337333grum_ped
guarded1036153guarded
guessed9176603guessed
guested9157713guested
guggled11338563guggled
guided94014113gu_ided
guiled84315383gu_iled
guised84612173gu_ised
gulfed114810013gu_lfed
gulfweeds1741743gulfweeds
gulled84521373gu_lled
gullied93812063gullied
gulped104610373gu_lped
gumless10228273gumless
gummer114615453gum_mer
gummers123712203gummers
gummier12349473gummier
gumshoed1542703gumshoed
gumtree1045873gumtree
gumtrees1143883gumtrees
gumwoods15123923gumwoods
gunned83513093gu_nned
gurged95513363gu_rged
gurgled10399123gurgled
gushed114816243gu_shed
gusseted1043553gusseted
gussied9267193gussied
gusted84316723gu_sted
gutted84716363gu_tted
guttered10259173guttered
guttled9378993guttled
guyed1049893gu__yed
guzzled17326263guzzled
hempweed1942803hempweed
hogweed1534443hogweed
humbled153711813humbled
hummed144812673hum_med
humored1336723humored
humped144015243hum_ped
humphed1835423humphed
humvee1439203humvee_
humvees1534683humvees
jumbled19379963jumbled
jumped183511553jum_ped
lumbered13188233lumbered
lumped114216963lum_ped
mayweed1634163mayweed
meed74934703__m_eed
mewed115218013__mewed
mumbled143010763mumbled
mummed104411553mum_med
mummied11327103mummied
mumped133813163mum_ped
numbed114111443num_bed
numbered13147143numbered
outweep1236673outweep
pigweed1465093pigweed
pinweed1346933pinweed
pumiced1435173pumiced
pummeled1543373pummeled
pumped133915563pum_ped
pureed95017813pu_reed
ragweed1235073ragweed
rumbaed12287493rumbaed
rumbled124514593rumbled
rumored1046643rumored
rumpled123810013rumpled
seaweed11108813seaweed
succeed1235983succeed
summed114014043sum_med
summered1338143summered
sumpweeds1742353sumpweeds
tarweed1137343tarweed
tumbled123412243tumbled
tumped114216233tum_ped
tweed94915093__tweed
umbeled12208193_umbeled
umbered121510113_umbered
umped104717273_um_ped
unmewed13258173unmewed
unwed94114873_unw_ed
waxweed2132923waxweed
weed85637513___weed
weeweed1435193weeweed

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 Filter1786911340270.420425454.8
2DLD Change Limit1340271356.37621020.5
3Display Results1351350.0462934.8
 (SQL Overall)1786911356.84226116.8
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.