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

84 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
coacervations205387(None) 
coacervation1964271coacervation_
conservations1849092conservations
coacervates1883593coacervat__es
conservation1749403conservation_
conversations1847453conversations
cooperations1659193cooper_ations
exacerbations2452503exacerbations
lacerations1348333_lacer_ations
macerations1548473_macer_ations
observations1785013_observations
aberrations1346694__aberrations
activations1669264__activations
aerations9317904__a_er_ations
botherations1754194bother_ations
cancelations1657094cance_lations
cancellations1754394cancellations
captivations1945344c_aptivations
carnations12311354c_a__rnations
caseations1258304c_ase__ations
castrations13410074c_astr_ations
catenations1348364c_ate_nations
clavations1546184cla___vations
coacervate1763724coacervat___e
coactions1349744coac____tions
coadaptations1851684coadaptations
coagulations1546514coa_gulations
coaptations1547544coa__ptations
coarctations16114494coa_rctations
cogenerations1655914cogener_ations
colorations13911894co_lor_ations
commendations2055804commendations
compellations1954814compellations
compensations19136184compensations
compurgations20123894compurgations
concentrations1877074concentrations
conceptions17410594conce__ptions
concertinos15158124concer__tinos
conciliations1747204conciliations
concretions1549294conc_r_etions
condemnations1845404condemnations
condensations1646274condensations
confirmations2055674confirmations
conformations2046724conformations
congelations1549734conge_lations
congregations17186414congregations
conjurations2148494conjur_ations
consecrations1749214consecrations
conservational1955344conservational
conservationist2084024conservationist
conservatisms2083534conservatisms
conservatives2195194conservatives
conservatizes27114454conservatizes
conservators1755974conservat_ors
consternations16116044consternations
contestations1547744contestations
conurbations1646664co_nurbations
conversation1747804conversation_
cooperation15410024cooper_ation_
corporations16129484corpor_ations
correlations1447864corre_lations
covariations1745984co_variations
cybernations1943604c_ybernations
deactivations19175064deactivations
deaerations12311674dea_er_ations
denervations1657094_denervations
enervations1478574__enervations
exacerbation2352954exacerbation_
inactivations1854244inactivations
incurvations1746384_incurvations
innervations1546924_innervations
laceration1249574_lacer_ation_
maceration1449614_macer_ation_
moderations1448274mo_der_ations
nervations1359484___nervations
observation1665064_observation_
operations12312954_o_per_ations
placentations17103634placentations
preservations1895544preservations
reactivations18176144reactivations
reservations1588584_reservations
starvations1445054sta__rvations
tolerations1158134to_ler_ations
ulcerations1346364_ulcer_ations

Search took 7 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.356501941.0
2DLD Change Limit95024846.11015552.2
3Display Results84840.0501680.0
 (SQL Overall)178691846.51627423.4
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.