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

39 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
equivocation265206(None) 
equivocations2751841equivocations
equivocating2751712equivocating
equivocator2561872equivocat_or
equitation1948343equi__tation
equivocality2961813equivocality
equivocate2452493equivocat__e
equivocated2652063equivocat_ed
equivocates2552403equivocat_es
equivocators2671673equivocators
evocation142010293e___vocation
advocation1645744__advocation
avocation14168994___avocation
bilocation1446124__bilocation
convocation1847884_convocation
echolocation1952814echolocation
edification1749354e_dification
education12310204edu___cation
eluviation1376614elu_v_iation
embrocation1744584e_mbrocation
equalization3049814equalization
equation17310484equ____ation
equilibration2462364equilibration
equinoctial2261554equinoc_tial
equitations2047444equi__tations
equivocal2352654equivoca___l
equivocalities28112074equivocalities
equivocally2852174equivoca_lly
estivation1349814estiv__ation
etiolation1048534e_ti_olation
evocations15259874e___vocations
exsiccation2243624exsi_ccation
exuviation20116344exu_v_iation
invocation1547544__invocation
provocation1847354_provocation
quotation18146974_qu__otation
revocation15410814__revocation
suffocation1953374_suffocation
vocation132311984____vocation

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 Limit124790397.17017404.5
3Display Results39390.0331181.8
 (SQL Overall)178691397.60923484.2
 
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.