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

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
redetermination18102291redetermination_
codetermination2062123codetermination_
determination1657643__determination_
determinations1766883__determinations
indetermination1863133indetermination_
extermination2275744_e_xtermination_
exterminations2365124_e_xterminations
pretermination1854774_pretermination_
preterminations1954294_preterminations
redetermining1752314redetermin__i_ng
determinative1954075__determinati_ve
determinatives2052935__determinatives
determinator1554575__determinat_o_r
determinators1653895__determinat_ors
exterminating2373855_e_xterminati_ng
predetermining2061755predetermin__i_ng
reexamination22153665re_e_xamination_
reexaminations23153415re_e_xaminations
termination131311165____termination_
terminational1553485____terminational
terminations14149755____terminations
deamination14411546__d__eamination_
deaminations151010126__d__eaminations
delamination1548856__de_lamination_
delaminations1647936__de_laminations
denomination15118826__de_nomination_
denominational1752526__de_nominational
denominations16117846__de_nominations
deterioration14145286__deterioration_
deteriorations15164676__deteriorations
determinacies1853196__determinaci_es
determinant1454736__determina___nt
determinate1446626__determinat___e
determinately1953196__determinat_ely
determining1545296__determin__i_ng
eternization2158666___eternization_
eternizations2258066___eternizations
exterminator2153256_e_xterminat_o_r
exterminators2252966_e_xterminat_ors
exterminatory2562486_e_xterminat_ory
germination14148976____germination_
germinations15137946____germinations
indeterminacies2061816indeterminaci_es
indeterminate1652986indeterminat___e
indeterminately21111966indeterminat_ely
nonterminating1773126_nonterminati_ng
peregrination16125206pere_gr_ination_
peregrinations17114686pere_gr_inations
predestination1765486pred__estination_
predestinations1865006pred__estinations
predomination1896536pred___omination_
predominations19105546pred___ominations
recontamination1983546recontamination_
recrimination1757406r__ecrimination_
recriminations1856726r__ecriminations
redecoration1545986redecor___ation_
redecorations1645056redecor___ations
rededication1646506red__e_dication_
rededications1746116red__e_dications
redefinition1652526red__e_finition_
redefinitions1752336red__e_finitions
redescription1862746redescr_i_ption_
redescriptions1962786redescr_i_ptions
redetermine14103696redeterm____i_ne
redetermined16102626redetermin____ed
redetermines15113416redetermin____es
regeneration1348196regener___ation_
regenerations1447136regener___ations
reiteration11412166re_iter___ation_
reiterations12410856re_iter___ations
renomination1499186r__e_nomination_
renominations15108296r__e_nominations
repatriation14126976repat_r_i_ation_
repatriations15136516repat_r_i_ations
terminating1447336____terminati_ng
westernisation17152566we_sternisation_
westernisations18172426we_sternisations
westernization26134466we_sternization_
westernizations27154116we_sternizations

Search took 10 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.376475242.0
2DLD Change Limit65874798.9207385.0
3Display Results79790.203389.2
 (SQL Overall)178691799.49918811.6
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.