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

125 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
grandma113691(None) 
grandam1139391grandam
grandmas1236921grandmas
grandpa1135411grandpa
grama85620282gra__ma
gramma11499802gra_mma
grana65722092gran__a
grand75122692grand__
grandad1038452grandad
grandame1247112grandame
grandams1237122grandams
granddad1244252granddad
granddam1344692granddam
grandee93115512grandee
grander93315872grander
grandly1238742grandly
grandmama1592382grandmama
grandpas1236002grandpas
grands84218242grand_s
granita82111302granita
granola837912granola
granum9310912granum_
anima74620073__anima
banda85223103_band_a
brahma1336193bra_hma
brand85124493brand__
branded114414103branded
brander103915823brander
brands95118943brand_s
brandy124712063brand_y
crania82418433cran_ia
drachma1544303drachma
drama85117413dra__ma
gama77035513g_a__ma
gamma106116103g_a_mma
gander84322763g_ander
ganja131410003g_an_ja
garda7316763g_ard_a
gerardia1044673gerardia
giardia945563giardia
girandola1152543girandola
gland75217713gland__
glandes95413833glandes
glands85314403gland_s
goanna736653goan_na
grad66829863gra_d__
grade75126093gra_d_e
graded94919553gra_ded
grader84919693gra_der
grades84926313gra_des
gradin83517483gra_din
grads75625753gra_d_s
gradual936943gra_dual
gradus84411213gra_dus
graham1237853graham_
grahams1335333grahams
gram77034583gra__m_
gramas94317203gra__mas
grammar12406893gra_mmar
grammas12499773gra_mmas
gramme114210333gra_mme
gramp106218323gra__mp
grampa115010173gra_mpa
grams85327313gra__ms
gran56335013gran___
granary1157793granary
grandads1136553grandads
grandames1346713grandames
grandbaby1851733grandbaby
granddads1343463granddads
granddams1443483granddams
grandees103211283grandees
grandest10311573grandest
grandeur10305673grandeur
grandkid1543643grandkid
grandmamas1672193grandmamas
grandpapa1552023grandpapa
grandsir1044313grandsir
grandson1055413grandson
grange83716203gran_ge
granger93514213granger
granges93516523granges
granitas92610223granitas
granite82017083granite
grannie8310353grannie
granny104311163gran_ny
granolas938053granolas
grans64832543gran__s
grant64840023gran__t
granted94715103granted
grantee83217133grantee
granter84117133granter
grantor84010933grantor
grants73722473gran_ts
grantsman1265053grantsman
granular946893granular
granule839473granule
granuloma1252393granuloma
grappa11396443gra_ppa
gravida12366563gravida
grind75917563grind__
grinded104210633grinded
grinder93312393grinder
grinds84511843grind_s
gringa838543grin_ga
landman1038923_landman
panama104213343_panama
panda85022613_pand_a
prandial1149643prandial
rand55839563_rand__
randan7315253_randan
random92513553_random
randoms102112433_randoms
rands65930453_rand_s
randy95022083_rand_y
ranula6311813_ranula
sandman10310173_sandman
scandia1038063scandia
sraddha1242083sraddha
sradha1085333sra_dha
trangam1039333trangam
trauma838803tra_uma
urania62516123uran_ia
vanda94515923_vand_a
veranda1156323verand_a

Search took 9 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.236757165.3
2DLD Change Limit1340271258.46615831.2
3Display Results1251250.156801.3
 (SQL Overall)1786911258.85820172.8
 
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.