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

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

96 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
identifiers155286(None) 
identifier1444261identifier_
identifies1445801identifie_s
identified1545052identifie_d
identities1146952identitie_s
acetifiers1543403ace_tifiers
certifiers1545143_certifiers
deifiers12348993_de__ifiers
denitrifiers1651913_denitrifiers
densifies1347993_densifie_s
gentrifiers1543003_gentrifiers
indemnifiers18111403indemnifiers
intensifiers15102633intensifiers
prettifiers1642513prettifiers
quantifiers2352503quantifiers
rectifiers1545173_rectifiers
reidentifies1663223reidentifie_s
testifiers13124503_testifiers
acetifier1444864ace_tifier_
acetifies1447134ace_tifie_s
beatifies1459284_beatifie_s
beautifiers1662214beautifiers
centiliters1343914_centiliters
certifier1447354_certifier_
certifies14310324_certifie_s
dandifies1476894_dandifie_s
defiers113913994_de___fiers
deifier113013124_de__ifier_
deifies113317454_de__ifie_s
denazifies2343294_denazifie_s
deniers84515184_den___iers
denitrifier1553124_denitrifier_
denitrifies1544264_denitrifie_s
densified1446714_densifie_d
densities10310794_densitie_s
denticles1237754_denticle_s
dentiform1543804_dentif_orm
dentifrices1751864_dentifrices
dentines93418404_denti_ne_s
dentitions1148854_dentitions
destinies10410844_destinie_s
destriers1038144_dest_riers
detickers1634424_de_tickers
dignifies1446364dign_ifie_s
diversifiers1982034diversifiers
edifiers12336674__e_difiers
enticers10139094__enti_cers
entities8617414__entitie_s
fortifiers1644534_fortifiers
gentrifier1444814_gentrifier_
gentrifies1446894_gentrifie_s
gratifiers1443864_gratifiers
idealities1148784idealitie_s
idealizers2043704ideali_zers
identifiable1882144identifiable
identifiably2192004identifiably
identify1544134identif___y
identifying1943494identifying
identikit1453464identiki__t
idoneities1144994idoneitie_s
ignifies1277564i_gn_ifie_s
indemnifier17102004indemnifier_
indemnifies17102954indemnifie_s
indenters102710034indent___ers
intensifier14113494intensifier_
intensifies14105334intensifie_s
justifiers2043084_justifiers
magnifiers1643814magn_ifiers
mentioners1245344_mentioners
misidentifies1991724misidentifie_s
mortifiers1544394_mortifiers
mystifiers1843114_mystifiers
notifiers1245024__notifiers
petrifiers1544674_petrifiers
prenotifies1644884prenotifie_s
prettifier1543974prettifier_
prettifies1545694prettifie_s
quantifier2243644quantifier_
quantifies2244754quantifie_s
ratifiers1236454__ratifiers
rectifier1457734_rectifier_
rectifies14310814_rectifie_s
reidentified1762934reidentifie_d
reifiers11309844_re__ifiers
renotifies1356894_renotifie_s
rentiers83311764_rent__iers
sanctifiers1652374sanctifiers
signifiers1444184sign_ifiers
specifiers1743804spe_cifiers
terrifiers13144574_terrifiers
testifier12116894_testifier_
testifies12139264_testifie_s
unidentified1752654unidentifie_d
unifiers11237174__un_ifiers
verifiers15166064_ve_rifiers
versifiers16154144_versifiers

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 Filter1786911488190.423422437.4
2DLD Change Limit148819968.37617767.3
3Display Results96960.0462087.0
 (SQL Overall)178691968.84520202.5
 
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.