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

47 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
prevaricates196323(None) 
prevaricate1863421prevaricate_
prevaricated20112861prevaricated
prefabricates2291842prefabricates
prevaricator1962402prevaricator
prevaricators2062202prevaricators
divaricates1743873_divaricates
predicates15410823pre__dicates
prefabricate2191873prefabricate_
prefabricated2391703prefabricated
prevaricating2153073prevaricating
prevarication2055243prevarication
prevarications2154743prevarications
revalidates1554353_revalidates
covariates1545784_covari_ates
demarcates1545974_demar_cates
divaricate1644274_divaricate_
divaricated1853494_divaricated
eradicates1348264__eradicates
evaginates1475994__evaginates
extricates1998244__extricates
metricates1449114_me_tricates
peregrinates1553354peregrinates
precipitates1854634precipitates
predicate14411784pre__dicate_
predicated1649144pre__dicated
predominates17125734predominates
prelocates1468354pre__locates
premeditates1753754premeditates
prenominates16166164prenominates
preprices1569264pre_pric__es
preterites12411794preteri__tes
radicates12412074_r__adicates
reanimates1247854_re_animates
rededicates15115074_rededicates
relubricates1653024_relubricates
repatriates1385324_repatri_ates
replicates1449454_re_plicates
reradiates11178014_reradi_ates
retaliates1049094_retali_ates
retardates1146434_retar_dates
revaccinates19143354_revaccinates
revalidate1454694_revalidate_
revalidated1654214_revalidated
revaluates13246794_reva_luates
rubricates1445894_r_ubricates
variates111214984___vari_ates

Search took 8 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 Filter1786911247900.406440125.6
2DLD Change Limit124790476.61018879.0
3Display Results47470.0331424.2
 (SQL Overall)178691477.04925349.8
 
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.