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

92 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
glorify144458(None) 
clarify1536092clarify
gloria71910552glori_a
glorias81610322glorias
gloried9169522gloried
glories81915922glories
glory96413292glor__y
gorily10612502g_orily
reglorify1651922reglorify
scorify1535202scorify
aerify122810113_aerify
clarity12310913clarity
clerisy1246823clerisy
codify1537163_codify
cornify1536253_cornify
florid10311453flori_d
floridly1554593floridly
florin9312653flori_n
florins10311643florins
florist10314243florist
fortify1636523_fortify
gasify1336333g_asify
gentrify1544683gentrify
glairy10448273gl_airy
glarier84112213glarier
glaring93714883glaring
glary96018543glar__y
glazily2035383glazily
gliff124915663gl__iff
globby1434683glo_bby
globin9309723globi_n
globing113210003globing
globins10278953globins
gloomily1443753gloomily
gloomy12528763glo_omy
gloppy1454723glo_ppy
glorified1445003glorified
glorifier1344233glorifier
glorifies1346363glorifies
glorifying1843673glorifying
gloriole944303gloriole
glorious946823glorious
glorying1335543glorying
glossily1235093glossily
glossy10549003glo_ssy
gloving12308443gloving
glowfly1742673glowfly
glowing123211793glowing
glozing18338893glozing
gluily10308293gl_uily
gonif94320923g_onif_
goniff13408893g_oniff
gonifs104310133g_onifs
goofily14105353goofily
goofy124915623g_o_ofy
gorier73719373g_orier
goring84119573g_oring
gorsy95915783g_or_sy
gory86129663g_or__y
gratify1436113gratify
griff124416463g__riff
grift95924463g__rift
grimy114312603g__rimy
gripy115115253g__ripy
gulosity1244443gulosity
horrify1635023horrify
jollify2044263jollify
logily1039833_logily
lordly1038753_lordly
lorica8310443_lorica
lories64933043_lories
loris55329153_lori_s
lorry86315673_lor_ry
lory75931713_lor__y
metrify1535623metrify
micrify1744693micrify
modify1537173_modify
mollify1555503mollify
mortify1536223_mortify
nigrify1444133nigrify
nitrify1335793nitrify
notify1236943_notify
petrify1536573petrify
ploidy1237483plo_idy
purify14399153_purify
rarify123210063_rarify
scarify1537443scarify
terrify1336353terrify
torrify1335013torrify
uglify1333913ugl__ify
verify153110163_verify
vitrify1645003vitrify

Search took 8 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.453394461.4
2DLD Change Limit134027927.47017942.0
3Display Results92920.0462000.0
 (SQL Overall)178691927.96922423.3
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.