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 “resuscitative” with Change Limit: [1] [2] [3] [4] [5] [6]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

75 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
resuscitative188235(None) 
resuscitate1352802resuscitat__e
resuscitating1662932resuscitating
resuscitation1554292resuscitation
recitative1548183re___citative
renunciative17103413renunci_ative
resuscitated1552563resuscitat_ed
resuscitates1452733resuscitat_es
resuscitations1673783resuscitations
resuscitator1461953resuscitat_or
resuscitators1561723resuscitators
denunciative18112794denunci_ative
elucidative1752604_elu_cidative
excitative2245024_e__xcitative
recitatives1645194re___citatives
recitativi1553744re___citativi
recitativo1555824re___citativo
reduplicative2172834reduplicative
associative1653855_associ_ative
assortative1473955_as_sortative
cunctative1744505__cunc_tative
depreciative2084085depreci_ative
desiccative1953945des_ic_cative
devastative1853435devas__tative
dissipative1753815dis_s_ipative
dissociative18133735dissoci_ative
educative15136555_edu_c__ative
estimative1546485_e__stimative
excogitative2562115_excogitative
expectative2553585_expec_tative
exploitative2452595_exploitative
frequentative28131765frequ_entative
gestative1347305ge__s__tative
gesticulative1962955gesticulative
gustative1345685__gus__tative
meditative1646285me___ditative
precipitative2253605pre_cipitative
premeditative2162915pre_meditative
presentative1755345pre__sentative
qualitative2353195__qualitative
ratiocinative1862215ratiocinative
recitation12315945re___citation
recitativos1652175re___citativos
recreative1549025re___creative
recriminative2053455recriminative
recuperative1954185recu_perative
reductive1547795redu_c___tive
reeducative1753515reeduc__ative
regulative1446985regu___lative
regurgitate1351905regurgitat__e
regurgitating1662205regurgitating
regurgitation15143405regurgitation
rehabilitative22141405rehabilitative
rehospitalize2762775rehospitalize
reluctate1146925relu_c_tat__e
reluctating1445765relu_c_tating
reluctation1347965relu_c_tation
remunerative1754765remu_nerative
renunciation1455315renunci_ation
replicative1846085re__plicative
representative19192315representative
resistive1247585re__s_i_stive
resocialize22115905res_oci_alize
respective1747625respec___tive
restorative1446945re__storative
restrictive1646365res_tri_ctive
resubmitting1752035resubmit_ting
resupinate1244425resu_pinat__e
resystematize27142695resystematize
retaliative1454985re_tali_ative
ruminative1546435r__u_minative
subcurative1854415__subcurative
substitutive1762355__substitutive
susceptive1754025__susc_eptive
sustentative15133105__sustentative

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 Filter1786911247900.403443402.0
2DLD Change Limit124790758.73614284.6
3Display Results75750.0461630.4
 (SQL Overall)178691759.18519454.7
 
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.