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

79 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
decortication185753(None) 
decortications1966771decortications
decorticating1984242decorticating
decorticator1762962decorticat_or
decertification2364323decertification
decoration13314423decor___ation
decorticate16134633decorticat__e
decorticated18144163decorticat_ed
decorticates17124333decorticat_es
decorticators1862493decorticators
deportation1449303deport__ation
detoxication2246203deto_xication
amortization2347204_amortization
coruscation1545694__coruscation
deactivation18156084de_activation
decantation1448944decant__ation
decapitation1748684dec_apitation
decarbonation18143984decarbonation
decerebration1884194decerebration
dechlorination2053414dechlor_ination
decimation15411624dec___imation
declination14411874dec__lination
decoction1447524deco___c_tion
decollation1448194deco__llation
decolonization26146024decolonization
decolorization26136414decolorization
decondition1545414decondi__tion
deconsecration1954784deconsecration
decontamination2083254decontamination
decorations14312884decor___ations
decrepitation1884804decrepitation
dedication14311964de___dication
defoliation1548314defo_li_ation
deforestation1754304deforestation
deformation1747664defor__mation
deification17411664de__ification
deionization2249884deio_nization
demarcation1647024demar__cation
democratization2963424democratization
demonetization2655874demonetization
demonization24410944demo_nization
demoralization26108624demoralization
denomination15118834deno_mination
denotation11311084deno_t__ation
densification1947334densification
deodorization2456464deodor_ization
deoxidation2045954de_o_xidation
deportations1548464deport__ations
deprecation1648964de_pr_ecation
depreciation1747074de_preciation
deprivation1788774de_pr_ivation
deputization2447224de_putization
derivation14712784de__r_ivation
desertification2154124desertification
destination12413844de__stination
determination1657644determination
detoxications2355654deto_xications
detoxification2754414detoxification
divarication1855904divar_ication
domestication18114544domestication
erotization20412064_ero_tization
excoriation2048434excor_i_ation
extrication2049794_extr_ication
fornication1645954__fornication
memorization2549924memor_ization
metrication15410654me_tr_ication
negotiation1245774nego_ti_ation
pectination15410334pec__tination
recertification2263984recertification
recodification22125664recodification
recombination19106174recombination
recompilation1955154recompilation
reconviction1955084reconvic_tion
recordation1449264recor__dation
rectification2049514rectification
refortification2373374refortification
remotivation1747434remo_tivation
securitization2554314securitization
urtication1249114___urtication

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.343520965.0
2DLD Change Limit95024795.40617577.5
3Display Results79790.0461717.4
 (SQL Overall)178691795.79530835.4
 
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.