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

116 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
geums8541411(None) 
gaums86217071gaums
gems75329111ge_ms
germs85118871germs
geum75424551geum_
glums84621421glums
gums75030941g_ums
neums75414251neums
alums75720602alums
arums75517832arums
beams95328172beams
begums11429492begums
berms95323662berms
bums85934592_bums
chums125015832chums
deems85421772deems
degums10438622degums
derms85022892derms
doums85417642doums
drums85415872drums
elms67322702_elms
ems56435492_e_ms
emus66821682_emus
fems96428702fe_ms
feuds95914882feuds
feus75830752feu_s
gams76648882g_ams
gauds75717722gauds
gaum75726422gaum_
gaurs66317992gaurs
gauss65613452gauss
gears64628692gears
gecks125117092gecks
geds66730812ge_ds
geeks104915842geeks
gees55647882ge_es
gelds75118342gelds
gels56836102ge_ls
gelts65924612gelts
gem66840222ge_m_
gemma106311772gemma
gemmy135211052gemmy
genes65133092genes
genoms94412482genoms
gens55740072ge_ns
gents65729612gents
genus65319832genus
germ75428962germ_
germy115113662germy
gests66028812gests
getas65421482getas
gets55442482ge_ts
getups9346852getups
glams85822932glams
gleams94812252gleams
glims87417672glims
gloms85219782gloms
glues65125682glues
glugs75214282glugs
glum75825102glum_
glume85120462glume
glumes94516812glumes
gluts66120132gluts
gnus56518002gnu_s
gorms85619592gorms
gouts64826172gouts
grams85327312grams
grubs86312602grubs
grues65721962grues
grum75625082grum_
grume86218162grume
grumes94415552grumes
grump105115312grump
grumps114510572grumps
guess64213362guess
guls55930852g_uls
gum67439532g_um_
guns55533482g_uns
guts56637252g_uts
guvs85816812g_uvs
guys85019642g_uys
gyms107514592g_yms
helms105619462helms
hems95534942he_ms
herms105626432herms
hums96831422_hums
leuds66214812leuds
lums65734242_lums
mems85931502me_ms
mums85732772_mums
neems77316292neems
neuks96510862neuks
neum66723082neum_
neume74414402neume
neumes83112622neumes
odeums9367312odeums
oleums8358782oleums
perms95524512perms
plums94619952plums
reams75729622reams
rems66237722re_ms
rheums1135462rheums
rums64833472_rums
scums95017422scums
seams75731662seams
sebums10369812sebums
sedums93910482sedums
seems75525022seems
serums83916302serums
slums74623432slums
stums75320082stums
sums65837582_sums
teams75726512teams
teems76019782teems
terms75523472terms
yeuks125110092yeuks

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.0961861364.6
2DLD Change Limit538001161.67032215.6
3Display Results1161160.0303866.7
 (SQL Overall)1786911161.79699493.9
 
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.