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

98 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
deferent12271287(None) 
deferents13269391deferents
deferment151210301deferment
referent112813421referent
afferent1447982afferent
decedent12310212decedent
deference1578492deference
deferments16128582deferments
deforest1238792deforest
detergent11129572detergent
determent121312902determent
deterrent10128942deterrent
different1646182different
efferent1447202efferent
referents12259642referents
reverent112615092reverent
adherent1247783adherent
afferents1546013afferents
befret11315963bef_re_t
besprent1248033besprent
cerement12315133cerement
coherent13412473coherent
dearest83618673de_arest
debarment1447793debarment
decadent1249003decadent
decedents1347323decedents
decent94023703d__ecent
decern91310953decer_n_
decerned1237263decerned
decerns10119053decer_ns
decrement14411053decrement
decurrent1256453decurrent
deepen9339193de_epen_
deepens10307813de_epens
deepest10310443de_epest
defacement1847003defacement
defeat103817163def__eat
defect124816173def__ect
defend113910493def__end
defendant1445443defendant
defer94619753defer___
deferences1677873deferences
deferential1554713deferential
deferral1244353deferral
deferred13106363deferred
deferrer12135593deferrer
deferrers13115153deferrers
deferring1436143deferring
defers105116943defer__s
deffest14308813def_fest
defiant11311923def_iant
deficient1547023deficient
defilement1648073defilement
definement1648063definement
deflect13399973def_lect
deforests1344373deforests
defrost1139553def_rost
deftest112611713def_test
dement93825153d__ement
demerit10314993demer_it
demurest1137453demurest
dependent1349113dependent
deponent11410553deponent
descent102616293de_scent
deselect1147523deselect
desert72725493deser__t
desinent9312963desinent
detent73624483d__etent
detergents12116663detergents
determents131010313determents
deterrents11126473deterrents
divergent1447363divergent
efferents1545333efferents
element9317803_element
emergent1149113_emergent
ferment12315573__ferment
fervent13310063__fervent
gerent73223103__gerent
inherent11412793inherent
leveret103014003levere_t
preferment1746323preferment
recement12315653recement
reerect92915883re_erect
referee101615753refere_e
refereed12149693refereed
referees111310413referees
reference14810093reference
referenda1343073referenda
refluent1147443refluent
reforest1139963reforest
refront10313263ref_ront
rerent63832453__rerent
revehent14239083revehent
reverend12288853reverend
sederunt945983sederunt
severest11310323severest
tenement10412593tenement
vehement1647763vehement

Search took 9 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 Filter1786911461620.860207780.2
2DLD Change Limit146162987.11020557.2
3Display Results98980.0462130.4
 (SQL Overall)178691988.01622291.8
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.