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

123 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
dignity123645(None) 
dignify1543891dignify
biggity1435012biggity
digit73825272dig_it_
digits84114532dig_its
dignitary1442462dignitary
dimity12310472di_mity
dingily1238102dingily
disunity1266012disunity
divinity1546162divinity
ignify1334512_ignify
ignite71410582_ignite
indignity1443962indignity
lignify1443792lignify
lignite81310302lignite
signify1444852signify
agility1148653agility
amenity1238333amenity
aminity12310513aminity
benignity1542813benignity
biggety1434433biggety
binit76431583bi_nit_
binits85716673bi_nits
dacoity1366183dacoity
dainty105311473dain_ty
dakoity1543423dakoity
damnify1643453damnify
deigning1137753deigning
deity94316773d__eity
density1137583density
dicliny1337673dicliny
dicty115116293di__cty
digamy1335893dig_amy
digest84019623digest_
digests93610613digests
digging113513703digging
dight104027003dig_ht_
dights114016963dig_hts
digital937063dig_ital
diglot83014333diglot_
diglots9299503diglots
dignities1149593dignities
dimwit1237953dimwit_
dimwits1344513dimwits
dingey114914053di_ngey
dinghy14476963di_nghy
dingier93513673dingier
dingies93618243dingies
dinging103618613dinging
dingy105721263di_n_gy
dining84525133di_ning
dinitro845563di_nitro
dinkey144812763di_nkey
dinkly144311083di_nkly
dinky135819373di_n_ky
dinning93416553dinning
dint56759053di_n_t_
dints67431313di_n_ts
diorite8314913diorite
dipnet91317473dipnet_
dipnets10109033dipnets
dirtily1138583dirtily
dirty95617803di__rty
disunite999303disunite
ditty95019293di__tty
dixit134420593di_xit_
dixits144210313di_xits
dizzily1934843dizzily
duality1147963duality
dunite7315013d_unite
dunnite857333dunnite
eighty133711603eig_hty
exiguity1942723exiguity
finite9316823fi_nite
finito9310303fi_nito
fixity19427803fi_xity
identity1245373identity
idoneity1243013idoneity
ignited9137623_ignited
igniter8147673_igniter
ignites81310583_ignites
ignitor8125263_ignitor
inanity1039503inanity
lenity9612713_lenity
lignin74911193ligni_n
lignins84010493lignins
lignites9129613lignites
lignitic1146393lignitic
linty87126563li_n_ty
magnify1634533magnify
malignity1543653malignity
mighty154310213mig_hty
minify1439253mi_nify
minty106323903mi_n_ty
nighty135611273nig_hty
nigrify1444133nigrify
ninety9510963ni_nety
pignut9311573pignut_
pignuts1035613pignuts
pigsty1235933pig_sty
pinite8321243pi_nite
piosity1268643piosity
reignite947233reignite
righty135011833rig_hty
rigidity1345253rigidity
sanity9316203_sanity
sienite7312713sienite
signet73621153signet_
signets83311503signets
signing92713963signing
signior835043signior
signiory1243563signiory
signory11427523signory
tinily94014433ti_nily
tinnily1047363tinnily
trinity10310843trinity
triunity1145073triunity
unity84918493__unity
vanity12311933_vanity
vicinity1645813vicinity
viduity1445343viduity
vinify1536923vi_nify
virginity1642813virginity

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 Filter1786911340270.403443402.0
2DLD Change Limit1340271235.92322628.2
3Display Results1231230.0761618.4
 (SQL Overall)1786911236.40227911.7
 
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.