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

83 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
desperate1241084(None) 
asperate10312372_asperate
deaerate9314172de_aerate
depurate1139982de_purate
desecrate1249082desecrate
desiderate1246272desiderate
desperado1383232desperado
desperately1753732desperately
despumate1443522despumate
deuterate1049512deuterate
disparate1249052disparate
reoperate11410182reoperate
temperate1348512temperate
asperated1239313_asperated
asperates11312553_asperates
aspirate1039943_aspirate
cooperate13710143cooperate
deaerated11311113de_aerated
deaerates10313633de_aerates
decelerate1347503decelerate
decorate11315193de_corate
defecate1438793de_fecate
degenerate1246833degenerate
dehydrate1744863dehydrate
delegate10410463de_legate
deliberate1347123deliberate
denervate1346173de_nervate
denigrate1168693denigrate
denitrate10810533denitrate
depauperate1652063depauperate
depilate11311703de_pilate
deprave1337073de_p_rave
deprecate1477433deprecate
depredate1345723depredate
depurated1338183de_purated
depurates1239813de_purates
derate74531233d___erate
desecrated1447953desecrated
desecrater1346983desecrater
desecrates1348833desecrates
desert72725493des_er_t_
deserted101012203des_er_ted
deserter91211603des_er_ter
deserts82513053des_er_ts
deserve11108703des_er_ve
desiccate1445923desiccate
desiderata1252733desiderata
desiderated1444943desiderated
desiderates1345813desiderates
designate1147113designate
desolate9411993des_olate
desperadoes1582583desperadoes
desperados1472983desperados
desperation14510113desperation
despite10410123desp__ite
despumated1643193despumated
despumates1543543despumates
dessert82916453desser_t_
desserts9247923desser_ts
deuterated1247533deuterated
deuterates1149083deuterates
disparage1346203disparage
disperse111011353disper_se
disrate81418523dis__rate
dissertate1145983dissertate
emeerate10410103_emeerate
esperance1346683_esperance
esterase849483_esterase
exasperate1954023exasperate
federate12310883fe_derate
generate9312903ge_nerate
operate9615733__operate
perpetrate1476643perpetrate
recuperate1445933recuperate
reiterate9412933reiterate
reoperated1348153reoperated
reoperates1249653reoperates
separate10310783se_parate
tesselate944183tesselate
tesserae844793tessera_e
venerate11312903ve_nerate
vesperal1344883vespera_l
vesperals1443933vesperals

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 Filter1786911486410.1731032896.0
2DLD Change Limit148641837.40620070.3
3Display Results83830.0461804.3
 (SQL Overall)178691837.62523434.9
 
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.