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

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

40 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
vicegerencies216121(None) 
vicegerency2261353vicegerenc__y
vicegerents1751553vicegeren__ts
coherencies1884774__coherencies
inherencies1656474_i_nherencies
vehemencies2152764v__ehemencies
vicegerent1652134vicegeren___t
ascendencies17103085asce_ndencies
belligerencies1971445belligerencies
clemencies1644735__c_lemencies
cogencies1448105__cog__encies
coherences1787045__coherenc_es
currencies1445665__c_urrencies
deferences1677875__deferenc_es
detergencies1654355__detergencies
differences2054915di_fferenc_es
divergencies1963575dive_rgencies
emergencies16124515___emergencies
excellencies2351995exce_llencies
inclemencies1853665_inclemencies
incoherences1954905incoherenc_es
indecencies1655825_i_ndecencies
inerrancies1355045_ine_rrancies
inferences15410345_i_nferenc_es
inherences1568965_i_nherenc_es
irreverences1752925irreverenc_es
itinerancies1452795_itinerancies
misreferences20102095misreferenc_es
nonemergencies1961645nonemergencies
precedencies1953725_precedencies
preferences1876185_preferenc_es
references1589355__referenc_es
regencies1249285__reg__encies
reverences1579175__reverenc_es
vagrancies1644175v__ag_rancies
vehemences2053435v__ehemenc_es
vibrancies1744415vi___brancies
vicereines1543775vic__ere_ines
virescences18134545vire_scenc_es
virulencies1652955vi__rulencies

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 Filter1786911247900.406440125.6
2DLD Change Limit124790408.29615042.2
3Display Results40400.0162500.0
 (SQL Overall)178691408.71820496.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.