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

114 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
collaborations187274(None) 
collaboration1763001collaboration_
collaborating1852582collaborati_ng
collaboratives21101942collaboratives
collaborators17142072collaborat_ors
collaborates1673683collaborat__es
collaborative2092383collaborati_ve
collaborator16142203collaborat_o_r
collocations1646403coll__ocations
colorations13911893co_l__orations
corroborations1882623corroborations
elaborations1444923__elaborations
calibrations1645154c_alib_rations
celebrations1645744c_eleb_rations
cohabitations2053454co_habitations
collaborate1593964collaborat___e
collaborated1772814collaborat__ed
collaboratively2571544collaboratively
collations12312854coll____ations
colligations1556834coll__igations
collimations1656874coll__imations
collocation1547174coll__ocation_
coloration12913184co_l__oration_
commemorations1953444commemorations
confabulations2162804confabulations
conflagrations2052724confla_grations
corporations16129484co__rporations
corroboration1782824corroboration_
elaboration1345744__elaboration_
syllabications2152024syllabications
abortions1147785____abor_tions
adorations11310235____adorations
alliterations1384555_alliterations
allocations1347775_all__ocations
ameliorations1563195amel_iorations
calibration1545995c_alib_ration_
carbonations1644845c__arbonations
castrations13410055c___astrations
celebration1546465c_eleb_ration_
cerebrations1646965c_ereb_rations
clavations1546185c__la__vations
coacervations2053875co__acervations
coadaptations1851685coada_ptations
coagulations1546515co__agulations
coalifications2155705coalifications
coaptations1547545co__a_ptations
coarctations16114495co__arctations
cogenerations1655915co_generations
cohabitation1953935co_habitation_
collateralizes2572485collateralizes
collation11313995coll____ation_
collections1547935coll___ections
colligation1457445coll__igation_
collimation1557575coll__imation_
collocating1645905coll__ocati_ng
collocational1753055coll__ocational
collodions1344595coll__o__dions
colonisations15216175co_lonisations
colonizations24229425co_lonizations
colorizations241410355co_lorizations
columniations1764795co_lumniations
combinations1897925co__mbinations
commemoration1853885commemoration_
commiserations2053455commiserations
concatenations1873725concatenations
concelebrations21103165conceleb_rations
concentrations1877075concentrations
condonations1548005co__ndonations
confabulation2063305confabulation_
confederations20104605confederations
configurations2063705configurations
conflagration1953015confla_gration_
conformations2046725co__nformations
conglobations1853945co_nglobations
conglomerations2062735conglomerations
conjurations2148495co__njurations
connotations1447285co__nnotations
consecrations1749215co_nsecrations
considerations1764845considerations
consolations1449745co__nsolations
conspirations1747725co_nspirations
contaminations1886105contaminations
contortions1348685co__ntor_tions
conurbations1646665conurb__ations
convocations1947365co__nvocations
cooperations1659195co__operations
coronations13410705co___ronations
corotations1349765co___rotations
corporation151210655co__rporation_
corroborating1862445corroborati_ng
corroborators1762045corroborat_ors
covariations1745985co_va_riations
declarations1546805decla__rations
deflagrations1883025defla_grations
deflorations1646065defl__orations
deliberations1645535_deliberations
elaborating1444865__elaborati_ng
evaporations1744695__evaporations
explorations2185615expl__orations
illustrations1353155_illustrations
jollifications26144595jollifications
lacerations1348335___lacerations
liberations1358945___liberations
librations12149065___lib_rations
malabsorptions2061045_malabsorptions
meliorations1466755_mel_iorations
mollifications21145205mollifications
obliterations1553455_obliterations
polarizations24219715po_larizations
pollinations1447235poll__inations
postabortion1662225postabor_tion_
solarizations22219275so_larizations
syllabication2052285syllabication_
tolerations1158135to_l__erations

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 Filter178691950240.360496363.9
2DLD Change Limit950241146.64014310.8
3Display Results1141140.0801425.0
 (SQL Overall)1786911147.08025238.8
 
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.