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

63 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
collaborative209238(None) 
collaboratives21101941collaboratives
collaborate1593962collaborat__e
collaborating1852582collaborating
collaboration1763002collaboration
collaboratively2571542collaboratively
collaborated1772813collaborat_ed
collaborates1673683collaborat_es
collaborations1872743collaborations
collaborator16142203collaborat_or
collaborators17142073collaborators
corroborative2062103corroborative
elaborative1653773__elaborative
collateralize2472694collateralize
colligative1754354coll__igative
commemorative2163044commemorative
comparative20176214compa__rative
corporative1847154co__rporative
abortive1346885____abor_tive
alliterative1553875_alliterative
ameliorative1752945amel_iorative
collaterality1862565collaterality
collateralized2672125collateralized
collateralizes2572485collateralizes
collective1747125coll___ective
collocate1348675coll__ocat__e
collocating1645915coll__ocating
collocation1547175coll__ocation
coloration12913185co_l__oration
combative1847215co__mb__ative
combinative2055135co__mbinative
commemoratives2262425commemoratives
commiserative2283275commiserative
comparatives21164855compa__ratives
concentrative2056215concentrative
confederative2253755confederative
configurative2262815configurative
conglomerative22132325conglomerative
connotative1665385co__nnotative
consecrative1957315co_nsecrative
contaminative2054375contaminative
contortive1546845co__ntor_tive
cooperative1847055co__operative
corroborate1562985corroborat__e
corroborating1862445corroborating
corroboration1782825corroboration
declarative1754315decla__rative
deliberative1854055_deliberative
dolabrate1244495do_lab_rat__e
elaborate1146885__elaborat__e
elaborating1444865__elaborating
elaboration1345745__elaboration
evaporative1953615__evaporative
explorative2354245expl__orative
illustrative1562505_illustrative
lacerative1556285___lacerative
meliorative1655155_mel_iorative
nonabrasive1652575no_nab_rasive
nonabsorptive2061865no_nabsorptive
nonnarrative1553835nonna_rrative
obliterative1753055_obliterative
tolerative1346255to_l__erative
unelaborate1352375unelaborat__e

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.390458182.1
2DLD Change Limit124790639.03313814.9
3Display Results63630.0461369.6
 (SQL Overall)178691639.46918871.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.