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

52 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
specifier164568(None) 
specified1746251specified
specifiers1743801specifiers
specifies1647571specifies
opacifier1643622opacifier
pacifier1557502_pacifier
specialer1344732specialer
specific1744702specifi_c
specifics1843932specifics
acetifier1444863acetifier
crucifier1644313crucifier
deifier113013123_de_ifier
edifier11309263__edifier
opacified1744393opacified
opacifiers1742513opacifiers
opacifies1645463opacifies
pacified1638363_pacified
pacifiers1645473_pacifiers
pacifies15311233_pacifies
peckier153910523_pec_kier
petrifier1447123_petrifier
purifier1338573_purifier
rectifier1457733_rectifier
reifier103414523_re_ifier
respecified1953373respecified
respecifies1853723respecifies
sanctifier1553493sanctifier
saponifier1542973saponifier
scarifier1446653scarifier
scorifier1445413scorifier
signifier1345713signifier
spacier114011633spac__ier
speciate12209583speciate_
speciated14207543speciated
speciates13229233speciates
specie10412223spec__ie_
species11314133spec__ies
specify1764993specif__y
specifying2144683specifying
specimen1444423speci_men
specter113111733spec__ter
speechified2251953speechified
speechifies2152203speechifies
speedier1146623spe_edier
spendier1147143spe_ndier
spicier115112463sp__icier
spiffier16255883sp_iffier
spikier13369983sp__ikier
spinier93715163sp__inier
spirier93214073sp__irier
unspecified1952653unspecified
verifier14159203_verifier

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 Filter1786911486410.420425454.8
2DLD Change Limit148641527.04621095.8
3Display Results52520.0163250.0
 (SQL Overall)178691527.48223882.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.