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

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

38 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
overcultivation2361561overcultivation_
cocultivation2053055__cocultivation_
cocultivations2152765__cocultivations
cultivation16116415____cultivation_
cultivations1745595____cultivations
noncultivation19183055_noncultivation_
noncultivations20182745_noncultivations
overestimation19125135over_estimation_
overestimations20124585over_estimations
recultivating1953015_re_cultivati_ng
cocultivating2162336__cocultivati_ng
cultivating1744946____cultivati_ng
deactivation18156086_deac__tivation_
deactivations19175066_deac__tivations
enculturation1552786__enculturation_
enculturations1652416__enculturations
occultation1545136o__ccult__ation_
occultations1644376o__ccult__ations
overapplication2462396overapplication_
overcutting1746826overcu_t___ti_ng
overestimating2054326over_estimati_ng
overmedication2263976over_medication_
overmedications2363626over_medications
overnutrition1663376overnu_t_rition_
overnutritions1763106overnu_t_ritions
oversaturation1794446over_saturation_
oversaturations1863936over_saturations
overtaxation2253676over___taxation_
overtaxations2353496over___taxations
overutilization2762676overutilization_
overvaluation1965086overval__uation_
overvaluations2064596overval__uations
reactivation17176956_reac__tivation_
reactivations18176146_reac__tivations
verbalization2769676_verbal_ization_
verbalizations2849166_verbal_izations
vernalization25410036_vernal_ization_
vernalizations2649246_vernal_izations

Search took 6 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.0931921408.6
2DLD Change Limit65874385.15612776.2
3Display Results38380.0301266.7
 (SQL Overall)178691385.27933849.4
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.