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

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

121 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
collaboration176300(None) 
collaborations1872741collaborations
collaborating1852582collaborating
collaborative2092382collaborative
collaborator16142202collaborat_or
collaborate1593963collaborat__e
collaborated1772813collaborat_ed
collaborates1673683collaborat_es
collaboratives21101943collaboratives
collaborators17142073collaborators
collocation1547173coll__ocation
coloration12913183co_l__oration
corroboration1782823corroboration
elaboration1345743__elaboration
calibration1545994c_alib_ration
celebration1546464c_eleb_ration
cohabitation1953934co_habitation
collaboratively2571544collaboratively
collation11313994coll____ation
colligation1457444coll__igation
collimation1557574coll__imation
collocations1646404coll__ocations
colorations13911894co_l__orations
commemoration1853884commemoration
confabulation2063304confabulation
conflagration1953014confla_gration
corporation151210654co__rporation
corroborations1882624corroborations
elaborations1444924__elaborations
postabortion1662224postabor_tion
syllabication2052284syllabication
abortion1048105____abor_tion
adoration10311315____adoration
alliteration1285165_alliteration
allocation1248575_all__ocation
amelioration1464005amel_ioration
antiabortion1462815antiabor_tion
calibrations1645155c_alib_rations
carbonation1545855c__arbonation
castration12410805c___astration
celebrations1645745c_eleb_rations
cerebration1547925c_ereb_ration
clavation1447005c__la__vation
coacervation1964275co__acervation
coadaptation1751965coada_ptation
coagulation1447275co__agulation
coalification2046135coalification
coaptation1448345co__a_ptation
coarctation1595075co__arctation
cogeneration1546445co_generation
cohabitations2053455co_habitations
collaterality1862565collaterality
collateralize2472695collateralize
collations12312855coll____ations
collection1448205coll___ection
colligations1556835coll__igations
collimations1656875coll__imations
collocating1645905coll__ocating
collocational1753055coll__ocational
collodion1244985coll__o__dion
colonisation14176765co_lonisation
colonization232010235co_lonization
colorization231711195co_lorization
columniation1665425co_lumniation
combination17108805co__mbination
commemorations1953445commemorations
commiseration1964045commiseration
concatenation1764095concatenation
concelebration20133565conceleb_ration
concentration1758015concentration
condonation1448855co__ndonation
confabulations2162805confabulations
confederation1995255confederation
configuration1954135configuration
conflagrations2052725confla_grations
conformation1947325co__nformation
conglobation1754255co_nglobation
conglomeration1963005conglomeration
conjuration2049515co__njuration
connotation1347985co__nnotation
consecration1649785co_nsecration
consideration1655525consideration
consolation13410985co__nsolation
conspiration1648385co_nspiration
contamination1766955contamination
contortion1248665co__ntor_tion
conurbation1547465conurb__ation
convocation1847885co__nvocation
cooperation15410025co__operation
coronation12412075co___ronation
corotation12410975co___rotation
corporations16129485co__rporations
corroborating1862445corroborating
corroborative2062105corroborative
corroborator1662015corroborat_or
covariation1646775co_va_riation
declaration1447835decla__ration
deflagration1773475defla_gration
defloration1547265defl__oration
deliberation1546365_deliberation
elaborating1444865__elaborating
elaborative1653775__elaborative
evaporation1645555__evaporation
exploration2066715expl__oration
illustration1253515_illustration
jollification25134845jollification
laceration1249575___laceration
liberation1269995___liberation
libration111510165___lib_ration
malabsorption1961265_malabsorption
melioration1368185_mel_ioration
mollification20135555mollification
obliteration1453895_obliteration
overelaboration2072255overelaboration
polarization232010435po_larization
pollination1348015poll__ination
postliberation1892055postliberation
proabortion1553165_proabor_tion
solarization211810175so_larization
syllabications2152025syllabications
toleration1048965to_l__eration

Search took 9 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.406440125.6
2DLD Change Limit1247901218.11015387.2
3Display Results1211210.0761592.1
 (SQL Overall)1786911218.59220797.4
 
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.