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

49 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
contemplations207473(None) 
contemplation1985261contemplation_
contemplating2054122contemplati_ng
contemplatives23122772contemplatives
contemplators1953572contemplat_ors
condemnations1845403condem_nations
congelations1549733conge__lations
constellations1654403conste_llations
contaminations1886103contaminations
contemplates1855283contemplat__es
contemplative22123703contemplati_ve
contemplator1853733contemplat_o_r
contestations1547733conte_stations
cancelations1657094cance__lations
cancellations1754394cance_llations
cantillations1545734cant_illations
commemorations1953444commemorations
compellations1954814compe_llations
compilations1848684co___mpilations
completions1746914co___mpletions
concentrations1877074concentrations
conceptions17410594conce_p__tions
condemnation1746044condem_nation_
condensations1646274conde_nsations
confabulations2162804confabulations
confederations20104604confederations
conflations16411144con___flations
congelation14410344conge__lation_
consecrations1749214conse_crations
conservations1849094conse_rvations
consolations1449744con__solations
constellation1554804conste_llation_
consternations16116044conste_rnations
constipations1747684constip_ations
consummations1955154consum_mations
consumptions1845144consump__tions
contamination1766954contamination_
contemplate1755204contemplat___e
contemplated1954444contemplat__ed
contemplatively2771894contemplatively
contemptuous1852054contemp__tuous
contentions13412094conte___ntions
contestation1448664conte_station_
continuations1547144cont_inuations
contraptions1647644contrap__tions
conversations1847454conve_rsations
correlations1447864corre__lations
interpolations1657434_interpolations
temptations1545414___temptations

Search took 5 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 Filter178691658740.313570897.8
2DLD Change Limit65874493.73317646.4
3Display Results49490.0331484.8
 (SQL Overall)178691494.07943807.6
 
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.