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

66 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
specified174625(None) 
specifier1645681specifier
specifies1647571specifies
opacified1744392opacified
pacified1638362_pacified
respecified1953372respecified
speciated14207542speciated
specific1744702specifi_c
specifics1843932specifics
specifiers1743802specifiers
speechified2251952speechified
unspecified1952652unspecified
acetified1545893acetified
aerified121310133_aerified
calcified1746893calcified
crucified1744683crucified
deified123112413_de_ified
dulcified1644463dulcified
edified12339713__edified
esterified1445403esterified
fancified1865793fancified
nancified1565543nancified
opacifier1643623opacifier
opacifies1645463opacifies
pacifier1557503_pacifier
pacifies15311223_pacifies
petrified1548333_petrified
prespecified2252593prespecified
purified1438743_purified
rectified1539243_rectified
reedified1446503reedified
reified112913783_re_ified
repacified1844893repacified
respecifies1853723respecifies
salified12310363s_alified
sanctified1644293sanctified
saponified1643493saponified
scarified1547293scarified
scorified1546193scorified
serifed11811463s_erif_ed
seriffed1594973s_eriffed
signified1446043signified
silicified1643493silicified
sissified1345543sissified
specced14266703spec__ced
specialer1344733specialer
specialised1654533specialised
specialized2545843specialized
speciate12209583speciate_
speciates13229233speciates
specie10412223spec__ie_
species11314133spec__ies
specify1764993specif__y
specifying2144683specifying
specimen1444423speci_men
specked16329013spec__ked
speckled17255833spec_kled
spectated14236593spectated
speechifies2152203speechifies
speiled104412123spe_i_led
speired103811103spe_i_red
spiffed16257103sp__iffed
spiffied17234823sp_iffied
stellified1443463stellified
verified151510393_verified
zincified2444293zincified

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.423422437.4
2DLD Change Limit148641667.15620771.5
3Display Results66660.0302200.0
 (SQL Overall)178691667.60923484.2
 
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.