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

43 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
sufficiencies236169(None) 
efficiencies2252522_efficiencies
insufficiencies2571282insufficiencies
deficiencies2052943_deficiencies
inefficiencies2462113inefficiencies
proficiencies2261813proficiencies
sufficiency2462163sufficienc__y
subjacencies2552274subjac_encies
subsciences1764364su_bscienc_es
sufficient1854224sufficien___t
sufficiently2362014sufficien_tly
affluencies19102565_aff_luencies
diffidences2153175diffi_denc_es
efficacies2052965_effic__acies
efficiency2352995_efficienc__y
esuriencies1353825esu___riencies
incipiencies1853715_incipiencies
insufficiency2671495insufficienc__y
lucencies1345845lu___c_encies
munificences2162325munific_enc_es
officiaries1952505_offici_aries
resiliencies1453725_resiliencies
reticencies1545685_retic_encies
saliencies1246135s___aliencies
sapiencies1445115s___apiencies
sciences1238775s____cienc_es
sentiencies1346325s__entiencies
stridencies1454035s_tri_dencies
stringencies1553525s_tringencies
subagencies1653485su__bagencies
sublicenses1553075sublic_en_ses
subpotencies1852585su_bpotencies
subscience1664545su_bscienc_e_
subserviencies2161215subserviencies
subsidences1653775subsi_denc_es
subsistences1653005subsistenc_es
subsocieties1652705subsocie_ties
sufferances1953375suff_eranc_es
sufficers17204535suffic_e___rs
suffices16208185suff__i__c_es
sufficing1844885suffici_n___g
suffixions2352195suffixion___s
superagencies1854745superagencies

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.1401276364.3
2DLD Change Limit124790438.31315011.4
3Display Results43430.0301433.3
 (SQL Overall)178691438.48321064.6
 
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.