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

52 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
procrastination1962451procrastination_
procrastinating2072192procrastinati_ng
procrastinator1881933procrastinat_o_r
procrastinators1981753procrastinat_ors
procrastinate1772374procrastinat___e
procrastinated1992054procrastinat__ed
procrastinates1882234procrastinat__es
predestination1765485pr_edestination_
predestinations1865005pr_edestinations
prognostication2082295prognostication_
repristination16204105_repristination_
repristinations17193925_repristinations
aromatization2457066aro_ma_tization_
aromatizations2576486aro_ma_tizations
castigation1447976___c_astigation_
castigations1547206___c_astigations
democratization2963416democra_tization_
parasitization2574056p__arasitization_
parasitizations2693566p__arasitizations
patination12312576p____a_tination_
patinations13411006p____a_tinations
pectination15410336p_ec___tination_
pectinations1649256p_ec___tinations
predestinating1854276pr_edestinati_ng
preordination1656156preor__dination_
preordinations1765706preor__dinations
prioritization2584156prior_itization_
prioritizations26123856prior_itizations
privatization2755866pr_iva_tization_
privatizations2855166pr_iva_tizations
proclamation1853416procla___mation_
proclamations1952696procla___mations
procreation1547946procr____eation_
procreations1647256procr____eations
profanation16186106pro_fa___nation_
profanations17175256pro_fa___nations
progestational1762756pro_gest__ational
prognosticating2172136prognosticati_ng
propitiation1656916pro__piti_ation_
propitiations1756206pro__piti_ations
proselytization29111906proselytization_
prostitution1454606pro___stitution_
prostitutions1554256pro___stitutions
prostration13410786pro___st_ration_
prostrations1449746pro___st_rations
protestation1456356pro_test__ation_
protestations1555796pro_test__ations
protonation13510426pro____tonation_
protonations1449046pro____tonations
recrimination1757406_recr_imination_
recriminations1856726_recr_iminations
repristinating1783066_repristinati_ng

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 Limit65874525.73311490.3
3Display Results52520.0461130.4
 (SQL Overall)178691525.87230431.0
 
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.