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

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

67 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
codetermination2062121codetermination_
determination1657643__determination_
determinations1766893__determinations
indetermination1863133indetermination_
redetermination18102293redetermination_
pretermination1854774_pretermination_
preterminations1954304_preterminations
consternation15106365conster__nation_
consternations16116045conster__nations
contamination1766955co_nt_amination_
contaminations1886105co_nt_aminations
determinative1954075__determinati_ve
determinatives2052935__determinatives
determinator1554575__determinat_o_r
determinators1653895__determinat_ors
extermination2275745__extermination_
exterminations2365125__exterminations
nonterminating1773125no_nterminati_ng
termination131311165____termination_
terminational1553485____terminational
terminations14149765____terminations
catheterization2962406catheter_ization_
cauterization24187756c_auter_ization_
cauterizations25197156c_auter_izations
cogeneration1546446cogener___ation_
cogenerations1655916cogener___ations
commination171111646co____mmination_
comminations18810486co____mminations
computerization3082786computer_ization_
condemnation1746046co_nde_m_nation_
condemnations1845406co_nde_m_nations
consternating1654976conster__nati_ng
contaminating1854916co_nt_aminati_ng
contemplation1985266co_nte_mplation_
contemplations2074736co_nte_mplations
coordination1595586co___ordination_
coordinations1684996co___ordinations
deamination14411546__d__eamination_
deaminations151010136__d__eaminations
delamination1548856__de_lamination_
delaminations1647946__de_laminations
denomination15118836__de_nomination_
denominational1752546__de_nominational
denominations16117856__de_nominations
deterioration14145286__deterioration_
deteriorations15164696__deteriorations
determinacies1853196__determinaci_es
determinant1454736__determina___nt
determinate1446626__determinat___e
determinately1953196__determinat_ely
determining1545296__determin__i_ng
eternization2158676___eternization_
eternizations2258076___eternizations
exterminating2373866__exterminati_ng
foreordination1892286fore_ordination_
foreordinations19102066fore_ordinations
germination14148976____germination_
germinations15137946____germinations
indeterminacies2061816indeterminaci_es
indeterminate1652986indeterminat___e
indeterminately21111966indeterminat_ely
modernisation1652766mod__ernisation_
modernisations1752726mod__ernisations
modernization2555336mod__ernization_
modernizations2654936mod__ernizations
redetermining1752316redetermin__i_ng
terminating1447356____terminati_ng

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 Filter178691658740.330541487.9
2DLD Change Limit65874677.0009410.6
3Display Results67670.0631063.5
 (SQL Overall)178691677.39324170.3
 
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.