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

36 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
equivocates255240(None) 
equivocate2452491equivocate_
equivocated2652061equivocated
equivocator2561872equivocator
equivocators2671672equivocators
equivocal2352653equivoca__l
equivocalities28112073equivocalities
equivocally2852173equivocally
equivocalness2761573equivocalness
equivocating2751713equivocating
equivocation2652063equivocation
equivocations2751843equivocations
equivokes2542173equivo__kes
equivoques2151343equivo_ques
advocates1545884__advocates
educates1139624edu___cates
edulcorates1452944edulcorates
eluviates1246104elu_v_iates
embrocates1665014e_mbrocates
equates162012324equ____ates
equilibrates2352604equilibrates
equinoxes2542844equino__xes
equipages2143124equi__pages
equipoises2162324equipo_ises
equites162212494equi____tes
equivocality2961814equivocality
equivoke2441984equivo__ke_
equivoque2051284equivo_que_
estivates12109754estiv__ates
etiolates949214e_ti_olates
exsiccates2142804exsi_ccates
exuviates1945374exu_v_iates
invocates1447644__invocates
quixotes2443554_quixo__tes
requiescats2251244requiescat_s
suffocates1843254_suffocates

Search took 9 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 Filter1786911488190.406440125.6
2DLD Change Limit148819368.48617537.0
3Display Results36360.0301200.0
 (SQL Overall)178691368.92220028.1
 
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.