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

44 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
insufficiencies2571281insufficiencies_
inefficiencies2462113in_efficiencies_
sufficiencies2361693__sufficiencies_
insufficiency2671494insufficienc___y
efficiencies2252525___efficiencies_
insufficient2062085insufficien____t
insufficiently2571655insufficien__tly
deficiencies2052946___deficiencies_
incipiencies1853716in___cipiencies_
indifferencies2362486indiff_erencies_
inefficacies2262166in_effic__acies_
inefficiency2562546in_efficienc___y
inefficients2062606in_efficien__ts_
insistencies1454056ins___istencies_
insurgencies1553586insu___rgencies_
proficiencies2261816__proficiencies_
sufficiency2462166__sufficienc___y
esuriencies1353827_esu___riencies_
incipiences1755167in___cipienc_es_
inconsistencies19132597inconsistencies_
incontinencies18163757inconti_nencies_
inconveniencies22152757inconveniencies_
incumbencies2053177incu___mbencies_
indecencies1655827in___dec_encies_
indifferences2262817indiff_erenc_es_
indigencies1555767in___di_gencies_
inefficient1953567in_efficien____t
inefficiently2462477in_efficien__tly
inexpediencies2662167in_expediencies_
infrequencies2762487in__frequencies_
innocencies15104967in___noc_encies_
insentiences1455467ins__entienc_es_
insistences1355587ins___istenc_es_
insolvencies1752937ins___olvencies_
insouciances1652537ins__oucianc_es_
insurgences1454637insu___rgenc_es_
intermittencies1961707intermittencies_
intumescences1983667intumesc_enc_es_
neurosciences1762647_neuroscienc_es_
resiliencies1453727res___iliencies_
subjacencies2552277__subjac_encies_
subsciences1764367__su_bscienc_es_
sufficient1854227__sufficien____t
sufficiently2362017__sufficien__tly

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 Limit95024449.00010558.2
3Display Results44440.0301466.7
 (SQL Overall)178691449.37319064.4
 
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.