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

109 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
specification224576(None) 
specifications2345351specifications
pacification2168052_pacification
acetification2046723acetification
calcification1945823calcification
deification17411663_de_ification
edification1749353__edification
esterification1995333esterification
pacifications2267353_pacifications
petrification2048813_petrification
purification1948173_purification
rectification2049513_rectification
reification16412903_re_ification
sanctification2154703sanctification
saponification21103533saponification
scarification2056403scarification
signification1986283signification
silicification2153163silicification
specialisation18182753specialisation
specialization27106283specialization
speciation1449393spec__i_ation
specificities2262593specificities
verification201810643_verification
acetifications2146054acetifications
acidification2154884acidification
amplification2275184amplification
basification19127324_basification
beatification20138074beatification
calcifications2045414calcifications
caprification2256054caprification
certification2048604certification
citification1949154_citification
clarification2045764clarification
coalification2046134coalification
codification20108074_codification
cornification2046694cornification
dandification2045904dandification
deifications18410654_de_ifications
densification1947334densification
edifications1848694__edifications
electrification2263414electrification
esterifications20134814esterifications
falsification2145244falsification
fortification2196924fortification
frenchification2872024frenchification
fructification2483674fructification
gasification1867104_gasification
glorification1984894glorification
gratification1946684gratification
humification2246104_humification
identification2054994identification
jollification25134844jollification
justification2546094justification
lignification19125704lignification
lithification21105164lithification
magnification2145764magnification
modification20107204_modification
mollification20135554mollification
mortification2087294mortification
mummification2154314mummification
mystification2346194mystification
nazification2646044_nazification
nidification1847454_nidification
nitrification1877064nitrification
notification1749064_notification
nullification1854694nullification
objectification3181874objectification
ossification17116544_ossification
pacificator2053544_pacificat_or
pectination15410334_pec_tination
petrifications2148024_petrifications
pontification2089014pontification
precipitation1966224precipitation
prettification21115714prettification
preunification2154304preunification
purifications2047464_purifications
qualification2745034qualification
ramification1998214_ramification
ratification17810664_ratification
recodification22125664_recodification
rectifications2148914_rectifications
reifications17411824_re_ifications
reunification18147454reunification
sanctifications2254134sanctifications
saponifications22133324saponifications
scarifications2155764scarifications
significations20125674significations
silicifications2253074silicifications
simplification2353384simplification
solidification2053554solidification
specialisations19132424specialisations
specializations28115634specializations
speciations1548484spec__i_ations
specifically2453474specifica_lly
specificity2382634specific__ity
speculation1547544spec__ulation
sterilization2258864sterilization
stratification1954674stratification
stultification1963904stultification
typification2244864_typification
uglification1845494_uglification
unification1648734__unification
verifications21159974_verifications
versification21157494versification
vilification2077124_vilification
vinification2068234_vinification
vitrification2166464vitrification
vivification2366344_vivification
zombification3154064zombification

Search took 6 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 Filter178691950240.356501941.0
2DLD Change Limit950241094.91019353.2
3Display Results1091090.0601816.7
 (SQL Overall)1786911095.32633550.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.