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

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

48 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
convalesced195214(None) 
convalesce1752981convalesce_
convalesces1853111convalesces
coalesced1444542co__alesced
convalescent1963122convalescent
coalesce1245413co__alesce_
coalesces1346033co__alesces
convalescence19132493convalescence
convalescents2062093convalescents
convalescing2052013convalescing
convulsed1544383convul_s_ed
covalence1645843co_valence_
covalences1745833co_valences
opalesced1442793_o_palesced
canalised12810914can_alis_ed
canvased14246214canva__s_ed
canvassed15274034canva__ssed
coalescent1496654co__alescent
coalshed1435014co__al_shed
coleseed1147394co___leseed
condescend1644414con__descend
condolence1565304condolence_
condolences1655284condolences
confessed1546054con__fessed
congested1338674con__gested
congressed1445464con_gressed
contested12310694con__tested
convalescences20122264convalescences
convected1738784conv__ected
convened143412224conv__e_ned
convented15410754conv__ented
converged1636964conv__erged
conversed1538684conv__ersed
converted15311564conv__erted
conveyed17247924conv__e_yed
convinced1745364conv__inced
convoluted1643704convol_uted
convolved1844084convol__ved
convulse1345444convul_s_e_
convulses1445504convul_s_es
covalencies1853994co_valencies
covalency1943834co_valenc_y
evanesced1562434__evanesced
nonvested1346004nonv__ested
obsolesced1551734_obsolesced
opalesce1243514_o_palesce_
opalesces1343994_o_palesces
uncoalesced1652154uncoalesced

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 Limit148819489.32615957.4
3Display Results48480.0163000.0
 (SQL Overall)178691489.49818813.5
 
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.