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

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

106 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
identifying194349(None) 
densifying1844812_densifying
reidentifying2151852reidentifying
acetifying1944453ace_tifying
beatifying1945733_beatifying
certifying1945313_certifying
dandifying1974313_dandifying
deifying1637633_de__ifying
denazifying2892393_denazifying
denitrifying2062663_denitrifying
dignifying1944153dign_ifying
gentrifying1943813_gentrifying
identified1545053identif_ied
identifier1444263identif_ier
identifies1445803identif_ies
identify1544133identify___
ignifying1744313i_gn_ifying
indemnifying2261543indemnifying
intensifying1982563intensifying
misidentifying2461023misidentifying
prenotifying2153053prenotifying
prettifying2044003prettifying
quantifying2743213quantifying
rectifying1946373_rectifying
renotifying1844183_renotifying
testifying1745403_testifying
aerifying1636494_ae_rifying
beautifying2043414beautifying
brutifying1943414_brutifying
carnifying1945044carn_ifying
citifying1845384__citifying
cornifying1944814corn_ifying
damnifying2043624_damnifying
decertifying2292794decertifying
defying15328824_de___fying
demystifying2551904_demystifying
dentifrice1652074_dentifrice
denting94422184_dent___ing
denying123711294_den___ying
desertifying2092874desertifying
destining11311434_desti_ning
destroying1564904_destroying
deticking1736044_de_ticking
detoxifying2652634_detoxifying
devitrifying2352184_devitrifying
disentitling1453634disentitling
diversifying2352164diversifying
dulcifying2043194_dulcifying
edifying1636084__e_difying
electrifying2153444electrifying
enticing11311804__enti_cing
entitling1037104__entitling
fancifying2243884_fancifying
fortifying2045154_fortifying
frenchifying2751734frenchifying
fructifying2352374fructifying
gratifying1874214_gratifying
idealising1245704ideali_sing
idealizing2147294ideali_zing
ideating10311704ideat___ing
identifiers1552864identifiers
identikit1453464identi_ki_t
identities1146954identi_ties
identity1245374identity___
indenting11911264indent___ing
indenturing1342874indent_uring
intitling1037214i__ntitling
introfying1744854i__ntrofying
inventorying1951284inventorying
jellifying2443884_jellifying
justifying2444054_justifying
lignifying1843524lign_ifying
magnifying2044034magn_ifying
mentioning1345794_mentioning
metrifying1945684_metrifying
minifying1845824_min_ifying
mortifying1944924_mortifying
mystifying2243944_mystifying
nidifying1744224nid___ifying
notifying1645624__notifying
objectifying3051694objectifying
overidentifying2671464overidentifying
petrifying1945824_petrifying
prenticing1547884prenti_cing
ratifying1656824__ratifying
recertifying2183234recertifying
reedifying1845244_reedifying
reifying1539384_re__ifying
retestifying1993414retestifying
reunifying1745164_reunifying
sanctifying2043284sanctifying
signifying1844414sign_ifying
specifying2144684spe_cifying
stellifying1842704stellifying
stratifying1843524stratifying
stultifying1852344stultifying
terrifying1745164_terrifying
unedifying1843724une_difying
unifying1537554__un_ifying
untidying1445474__untidying
verbifying2244354_verbifying
verifying1936414_ve_rifying
versifying2045034_versifying
vinifying1944714_vin_ifying
zincifying2843254_zincifying
zinkifying3042684_zinkifying

Search took 10 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 Filter1786911488190.453394461.4
2DLD Change Limit1488191068.50017508.1
3Display Results1061060.0462304.3
 (SQL Overall)1786911068.99919856.8
 
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.