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

155 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
desiderates134581(None) 
desiderate1246271desiderate_
desiderated1444941desiderated
deliberates1446792deliberates
desiderata1252732desiderat_a
desideratum1551172desideratum
deaerates10313643de__aerates
decelerates1446793decelerates
degenerates1346453degenerates
dehydrates1844243dehyd_rates
deliberate1347123deliberate_
deliberated1545633deliberated
delineates1147123deline_ates
denigrates1298113deni_grates
denitrates1169513deni_trates
desecrates1348843des_ecrates
desiccates1545383desi_ccates
desiderating1544693desiderating
desideration1456393desideration
desiderations1545673desiderations
desiderative1753683desiderative
designates1246363desi_gnates
desperate12410843des_perate_
deuterates1149083de_uterates
federates13310153fe__derates
reiterates10412003re_iterates
siderites10410433__siderites
acierates11310814_aci_erates
aliterates101510754_aliterates
alliterates11106254alliterates
asperates11312554_as_perates
asseverates1452644asseverates
considerate1455474considerate_
deaerate9314174de__aerate_
deaerated11311114de__aerated
debilitates1444474debilitates
decelerate1347504decelerate_
decelerated1545924decelerated
decerebrates1753594decerebrates
deciders123510754decider___s
deciduate1345064decid_uate_
decimates14410694deci__mates
decorates12314744de__corates
dedicates13311694de__dicates
defecates1538594de__fecates
deflagrates16133244deflagrates
degenerate1246834degenerate_
degenerated1445744degenerated
dehydrate1744864dehyd_rate_
dehydrated1943494dehyd_rated
delegates1139844de__legates
deliberately1852434deliberately
delicates12314314deli__cates
delineate1047794deline_ate_
delineated1246244deline_ated
deliverances18142694deliverances
deliveries1446014deliver_ies
demodulates1543754demodulates
dendrites1147934de_nd_rites
denervates1445934de__nervates
denigrate1168694deni_grate_
denigrated1366974deni_grated
denitrate10810534deni_trate_
denitrated1298034deni_trated
denudates1145584denud__ates
depilates12310924depi__lates
deprecates1547284de_precates
depredates1445494de_predates
depurates1239824de__purates
derates84028894____derates
deriders102411854derider___s
derivates13310094deri__vates
desalinates1246214desalinates
desecrate1249084des_ecrate_
desecrated1447954des_ecrated
desecrater1346984des_ecrater
desecraters1444814des_ecraters
desegregates1552934desegregates
deserted101012204des__er_ted
deserter91211604des__er_ter
deserters10129984des__er_ters
deserts82513054des__er_t_s
deserves12109894des__er_ves
desiccate1445924desi_ccate_
desiccated1644994desi_ccated
designate1147114desi_gnate_
designated1345934desi_gnated
desinences1347214desine_nces
desirables1344214desi__rables
desirers939264desirer___s
desires81316134desi__r__es
desolates10311794des__olates
desperadoes1582584des_peradoes
desperados1472984des_perados
desperately1753734des_perately
despumates1543544des_pumates
desquamates2351534desquamates
desserts9247924des_ser_t_s
deuterate1049514de_uterate_
deuterated1247534de_uterated
deviates12312734devi___ates
dimidiates1444604dimid_iates
disintegrates1583124disintegrates
disrates91118154d__i_srates
dissertates1245344dis_sertates
emeerates1149374_e_meerates
emigrates1248584_emi_grates
emirates101214854_emi__rates
enumerates12126744_enumerates
epimerases1443584_epimerases
esterases949634_es_terases
eviscerates1652854_eviscerates
exonerates17107344_exonerates
exuberates1945284_exuberates
federate12310884fe__derate_
federated1438424fe__derated
generates10312714ge__nerates
hesitates1269794hesi__tates
ideates8313734___ide_ates
illiterates11115654illiterates
incinerates1346034incinerates
iterates81317824___iterates
itinerates10126134_itinerates
levirates1247494levi__rates
liberates111012944__liberates
literates91415654__literates
meliorates1288904meli_orates
moderates12710754__moderates
obliterates1345124obliterates
perseverates1753154perseverates
preliterates1455344preliterates
recuperates1545604recuperates
refrigerates1653504refrigerates
regenerates1247474regenerates
rehydrates1744464rehyd_rates
reiterate9412934re_iterate_
reiterated11410154re_iterated
remigrates1348584remi_grates
remunerates1375944remunerates
reoperates1249664re_operates
residences1368234reside_nces
residencies1445974residencies
residents1038424reside_nt_s
residers93311884resider___s
resinates9314764resi__nates
resituates1047754resi_tuates
revibrates1546274revi_brates
siderite9411364__siderite_
sideroses1047354__sideroses
tesselates1043934tes_selates
venerates12312264ve__nerates
vesicates14119034vesi__cates
vesiculates1646294vesiculates
vizierates2243244vizi_erates
vociferates1982544vociferates

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.1561145455.1
2DLD Change Limit1488191559.23616112.9
3Display Results1551550.0762039.5
 (SQL Overall)1786911559.46818873.2
 
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.