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

114 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
grandeur1030567(None) 
grander93315871grande_r
grandeurs11335111grandeurs
brander103915822brande_r
frondeur1242792frondeur
gander84322762g_ande_r
grader84919692gra_de_r
grandee93115512grande_e
grandees103211282grandees
grandest10311572grandest
grandsir1044312grandsir
granger93514212grange_r
granter84117132grante_r
grinder93312392grinde_r
bander93928223_bande_r
blander103715163blande_r
braider105112993braide_r
branded114414103brande_d
branders114313093branders
branner94212373branne_r
candour104210243_candour
cranker133612793cranke_r
dander811222993_dande_r
danseur833663_danseur
flaneur1034183flan_eur
franker143510183franke_r
frondeurs1342573frondeurs
gadder93714713g_adde_r
ganders93521703g_anders
ganger83721463g_ange_r
garner73917003garn_e_r
gender83517933g_ende_r
germander1345363germande_r
gladder10398313gladde_r
glancer103710073glance_r
glanders103811503glanders
glandes95413833glande_s
grabber12389763grabbe_r
grade75126093gra_de__
graded94919553gra_de_d
graders94716013gra_ders
grades84926313gra_de_s
gradus84411223gra_d_us
grafter114211153grafte_r
grainer83714063graine_r
grainier9218903grainie_r
grand75122693grand___
grandad1038453grand_ad
grandads1136553grandads
grandam1139393grand_am
grandame1247113grandame
grandams1237123grandams
grandaunt1144703grandaunt
granddad1244253granddad
granddam1344693granddam
grandkid1543643grandkid
grandly1238743grand_ly
grandma1136913grand_ma
grandmas1236923grandmas
grandness1138303grandness
grandpa1135413grand_pa
grandpas1236003grandpas
grands84218243grand__s
grandsire1145123grandsire
grandsirs1144553grandsirs
grandson1055413grandson
grange83716203grange__
grangers103011973grangers
granges93516523grange_s
granted94715103grante_d
grantee83217133grante_e
grantees92510973grantees
granters93614143granters
grantor84010933gran_tor
granular946893granular
granum9310913gran__um
grapier103712603grapie_r
grasper10389793graspe_r
grater74625443gra_te_r
graver105018593gra_ve_r
grayer106014543gra_ye_r
grazer164815763gra_ze_r
grazier173611133grazie_r
gridder10367763gridde_r
grinded104210633grinde_d
grinders103410423grinders
grindery13255513grindery
grinner8329233grinne_r
groaner82510133groan_e_r
grounder1047613grounde_r
grunger9389783grunge_r
grunter83110783grunte_r
guarder936463guarde_r
hander104526433_hande_r
lander74028483_lande_r
meander1049973meande_r
pander93725523_pande_r
pandour10408213_pandour
prancer113613383prance_r
raider74318743_raide_r
rancour987133_rancour
randier83618473_randier
ranger73925523_range_r
ranker105021903_ranke_r
ranter63826823_rante_r
render74024143_rende_r
sandbur10105353_sandbur
sander74828533_sande_r
slander84015443slande_r
stander84316163stande_r
strander97112063strande_r
trader75218763tra_de_r
wander104423713_wande_r
zander163417113_zande_r

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 Limit1461621146.51622431.2
3Display Results1141140.0462478.3
 (SQL Overall)1786911146.98225593.1
 
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.