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

53 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
efficaciously266163(None) 
efficacious2151612efficacious__
inefficaciously289972inefficaciously
officiously2254213offi__ciously
efficacies2052964efficaci_es__
efficaciousness2561594efficaciousness
efficacity2352044efficaci___ty
fallaciously2053134_fallaciously
inefficacious2361034inefficacious__
perspicaciously2691334perspicaciously
pertinaciously2162214pertinaciously
vicariously1954794__vicariously
vivaciously2253884__vivaciously
audaciously1754625__audaciously
bodaciously1953995__bodaciously
capaciously2054955__capaciously
deliciously1755135deli__ciously
efficacities2252195efficaci_ties
efficacy2152525efficac_____y
efficiently2252935effi__ciently
ericaceous1453185e_ricaceous__
facetiously1954585__facetiously
factiously1886435__fac_tiously
felicitously2053115felic_itously
ferociously1955185__ferociously
fictitiously2053715__fictitiously
flirtatiously1962005_flirtatiously
fractiously1985535_frac_tiously
graciously1646185___graciously
hellaciously2063085_hellaciously
hilariously1774345__hilariously
infectiously2054085infec_tiously
judiciously2454355judi__ciously
loquaciously2652485_loquaciously
maliciously1855115mali__ciously
mendaciously2073605_mendaciously
nefariously1754495nef__ariously
officious1763875offi__cious__
perfidiously2153685perfi__diously
perniciously1954805perni__ciously
precariously1954135_precariously
precociously2153965_precociously
pugnaciously2053015_pugnaciously
rapaciously1854665__rapaciously
sagaciously1754545__sagaciously
salaciously1655315__salaciously
sequaciously2653445_sequaciously
spaciously1746405___spaciously
tenaciously1655305__tenaciously
ungraciously1853745_ungraciously
veraciously1955705__veraciously
viciously1746395__vi__ciously
voraciously1955145__voraciously

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.390458182.1
2DLD Change Limit124790538.09315419.5
3Display Results53530.0331606.1
 (SQL Overall)178691538.51620983.0
 
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.