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

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
prognosticators2071911prognosticators_
prognosticator1972192prognosticator__
prognosticates1972593prognosticat_es_
prognosticate1882734prognosticat___e
prognosticated2082464prognosticat__ed
prognosticating2172134prognosticat_ing
prognostication2082294prognosticat_ion
prognosticative2381804prognosticat_ive
procrastinators1981765procrastinators_
prognostics1653735prognostic____s_
pontificators2053056p_o_ntificators_
predestinators1762506pr_edestinators_
procrastinator1881946procrastinator__
prognostic1554776prognostic______
propitiators1653966pro__piti_ators_
prostitutors1452916pr___ostitutors_
rusticators1344946_r___usticators_
coconspirators2061437_coconspirators_
coinvestigators21101387_coinvestigators_
consolidators1653297_co_nsolidators_
conspirators1655537_co_n_spirators_
constrictors1676017_co_n_stric_tors_
decorticators1862507__decorticators_
fornicators1663737_forn___icators_
instigators1245927___in_stigators_
masticators1546327____masticators_
negotiators1253167_neg_o_ti_ators_
pontificator1953467p_o_ntificator__
postulators1345257p____ostulators_
potentiators1453237p_o_tenti_ators_
predestinator1662987pr_edestinator__
prevaricators2062207pr__evaricators_
procrastinates1882237procrastinat_es_
progenitors1454247prog__eni__tors_
prognosis1246727prognos_i_____s_
prolocutors1563117pro_lo___cutors_
pronators11411307pro_n_____ators_
propitiator1554227pro__piti_ator__
propitiatory1963387pro__piti_ator_y
prosectors14199137pr___os_ec_tors_
prosecutors1564467pr___os_ecutors_
prospectors1754587pr___ospec_tors_
prostitutor1353137pr___ostitutor__
protectors142010147pr___o_tec_tors_
protostars1246867pro_tost__a__rs_
protractors1546627pr___o_tractors_
remonstrators1583567_remonst_rators_
rusticator1245327_r___usticator__
sonicators1277067_so_n___icators_

Search took 10 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.343520965.0
2DLD Change Limit95024499.26610255.1
3Display Results49490.0301633.3
 (SQL Overall)178691499.63918538.3
 
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.