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

94 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
grandeurs1133511(None) 
grandeur10305671grandeur_
branders114313092brande_rs
frondeurs1342572frondeurs
ganders93521702g_ande_rs
glanders103811502glande_rs
graders94716012gra_de_rs
grandees103211282grande_es
grander93315872grande_r_
grandsirs1144552grandsirs
grangers103011972grange_rs
granters93614142grante_rs
grinders103410422grinde_rs
banders104324563_bande_rs
braiders114110573braide_rs
brander103915823brande_r_
branners104010923branne_rs
candours11408643_candours
danders93921183_dande_rs
danseurs933433_danseurs
flaneurs1133953flan_eurs
frankers15348353franke_rs
frondeur1242793frondeur_
gadders103611503g_adde_rs
gander84322763g_ande_r_
gangers94418603g_ange_rs
garners83815983garn_e_rs
genders93616783g_ende_rs
germanders1444603germande_rs
glancers11408003glance_rs
glandes95413833glande__s
grabbers13337883grabbe_rs
grader84919693gra_de_r_
grades84926313gra_de__s
gradus84411223gra_d_u_s
grafters12409193grafte_rs
grainers93012073graine_rs
grandads1136553grand_ads
grandames1346713grandames
grandams1237123grand_ams
grandaunt1144703grandaunt
grandaunts1252943grandaunts
granddads1343463granddads
granddams1443483granddams
grandee93115513grande__e
grandest10311573grande_st
grandkids1643143grandkids
grandmas1236923grand_mas
grandness1138303grandness
grandpas1236003grand_pas
grands84218243grand___s
grandsir1044313grandsir_
grandsire1145123grandsire
grandsires1245043grandsires
grandsons1145123grandsons
granger93514213grange_r_
granges93516523grange__s
grantees92510973grante_es
granter84117133grante_r_
grantors93810353gran_tors
graspers11338403graspe_rs
graters85419743gra_te_rs
gravers114515273gra_ve_rs
grazers175112453gra_ze_rs
graziers18387123grazie_rs
gridders11286293gridde_rs
grinder93312393grinde_r_
grindery13255513grinde_ry
grinners9288043grinne_rs
groaners9248503groan_e_rs
grounders1156783grounde_rs
grungers10298503grunge_rs
grunters9359033grunte_rs
guarders1035883guarde_rs
handers114224333_hande_rs
landers84026213_lande_rs
meanders1168833meande_rs
panders103423733_pande_rs
pandours11317993_pandours
prancers123210333prance_rs
raiders84615143_raide_rs
rancours1076713_rancours
rangers83621043_range_rs
rankers113217463_ranke_rs
ranters73323643_rante_rs
renders83821673_rende_rs
sandburs11105623_sandburs
sanders84025943_sande_rs
slanders94014013slande_rs
standers93514303stande_rs
stranders10389933strande_rs
traders84316953tra_de_rs
wanders114221333_wande_rs
zanders173015793_zande_rs

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 Filter1786911486410.1561145455.1
2DLD Change Limit148641947.84318952.1
3Display Results94940.0462043.5
 (SQL Overall)178691948.04522211.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.