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 “grandame” with Change Limit: [1] [2] [3] [4]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

76 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
grandame124711(None) 
grandam1139391grandam_
grandames1346711grandames
grandams1237121grandams
gradate9511232gra_date
grandad1038452granda_d
grandads1136552grandads
granddam1344692granddam_
granddams1443482granddams
grandee93115512grand_ee
grandma1136912grand_ma
grandmama1592382grandmama
grandmas1236922grandmas
bandage11311023_bandage
craniate10312563craniate
gendarme1243523g_endarme
girandole1143543girandole
glandule1043853glandule
gradable1238823gra_dable
gradated1157433gra_dated
gradates10510783gra_dates
grade75126093gra_d__e
gradine93317033gra_dine
graduate1058083graduate
graftage1343683graftage
graham1237853gra_ham_
grahams1335333gra_hams
gramme114210333gra__mme
grana65722093gran_a__
granary1157793gran_ary
grand75122693grand___
grandaddy1652113grandaddy
grandaunt1144703grandaunt
grandbaby1851733grandbaby
granddad1244253granddad
granddads1343463granddads
grandees103211283grandees
grander93315873grand_er
grandest10311573grandest
grandeur10305673grandeur
grandiose1145793grandiose
grandkid1543643grandkid
grandly1238743grand_ly
grandmamas1672193grandmamas
grandpa1135413grand_pa
grandpapa1552023grandpapa
grandpas1236003grandpas
grands84218243grand__s
grandsir1044313grandsir
grandsire1145123grandsire
grandson1055413grandson
grange83716203gran__ge
granite82017083gran_ite
grannie8310353gran_nie
grantable1257293grantable
grantee83217133gran_tee
grantsmen1294643grantsmen
granulate1059183granulate
granule839473gran_ule
granum9310913gran_um_
grapheme1644013grapheme
gravamen1443933gra_vamen
gravidae13324793gravida_e
grenade938413gren_ade
guanase836213guan_ase
madame1139853_ma_dame
mandate10315573_mandate
prename11412643pren_ame
radome9511873_ra_dome
randan7315253_randa_n
randans8313213_randans
random92513553_random_
randoms102112433_randoms
rename82718813_ren_ame
trangam1039353trangam_
trangams1147203trangams

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 Filter1786911461620.420425454.8
2DLD Change Limit146162766.47022590.7
3Display Results76760.0302533.3
 (SQL Overall)178691766.92025822.4
 
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.