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

114 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
devotements174561(None) 
denotements1446861denotements
devotement1646281devotement_
debatements1656042debatements
denotement1347972denotement_
denouements1446472denouements
debasements1666173debasements
debatement1547073debatement_
decrements1549383de_crements
defacements1946073defacements
defilements1747073defilements
definements1747113definements
deforcements2054663deforcements
denouement1357503denouement_
denudements1545333denudements
deportments1655753deportments
determents131010313de__terments
devilments1646383dev_ilments
devotedness1653703devotedness
devotees12286283devote_e__s
divorcements2054413divorcements
elopements14146363_elopements
evolvements1953743_evolvements
revetments1546433revet_ments
revilements1647133revilements
abatements1446354_abatements
advisements1754824advisements
allotments1244464allot_ments
atonements1247204_atonements
battements1455814_battements
bemusements1754444bemusements
besetments1445294beset_ments
betterments1544714be_tterments
bodements1447614__bodements
cajolements2254164cajolements
cerements13411454ce__rements
debarments1545854de_barments
debasement1547294debasement_
debouchments2272444debouchments
debridements1853894debridements
decampments2073524decampments
decedents1347324de__cedents
decrement14411054de_crement_
defacement1847004defacement_
deferents13269394de__ferents
deferments16128584de_ferments
defilement1648074defilement_
definement1648064definement_
deforcement1954984deforcement_
dements103016624d____ements
denouncements18143804denouncements
denudement1445894denudement_
departments1645794departments
deployments1954244deployments
deponents1246674depo__nents
deportment1546774deportment_
depravements2054454depravements
derailments1446104derailments
derangements1665824derangements
designments1545124designments
despisements1785164despisements
despoilments1753404despoilments
detachments1954594detachments
detainments1485894detainments
detents83615154de__t__ents
detergents12116664de__tergents
determent121312904de__terment_
deterrents11126474de__terrents
dethronements1962774dethronements
detriments1347364de_triments
developments2053344developments
devilment1547714dev_ilment_
devotee113811824devote_e___
devotes113713754devot__e__s
devotions1356594devot_ion_s
disownments17114904disownments
divestments17155164divestments
divorcement1954694divorcement_
documents1446524d__ocuments
easements11410334_e_asements
elements10312174_e__lements
eloinments1245994_eloinments
elopement13118224_elopement_
emblements1647794_emblements
emoluments1455424_emoluments
evolvement1853914_evolvement_
excitements2254284excitements
excrements2146984_excrements
extolments1944404_extolments
feoffments17122174fe_offments
incitements1556294incitements
involvements2053374involvements
movements1647514__movements
pavements1647004pav__ements
ravagements1754164ravagements
recements13312284re__cements
recoupments1753774recoupments
recrements1449354re_crements
refinements1646794refinements
remitments1446844remit_ments
restatements1455284restatements
retirements1357614retirements
revealments1644494revealments
revelments1546864rev_elments
revetment1448324revet_ment_
revilement1548484revilement_
securements1545494securements
seducements1654494seducements
sentiments1248274se_ntiments
settlements1345544settlements
statements1256884_statements
tenements1149964te__nements
testaments1265354te_staments
vestments1486814ve_st_ments

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 Filter1786911488190.436409841.7
2DLD Change Limit1488191148.73617035.1
3Display Results1141140.0601900.0
 (SQL Overall)1786911149.23219355.6
 
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.