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

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

41 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
opercula124499(None) 
opercular1345081opercular
opercule1245281opercule
opercele1244592opercele
operculars1443682operculars
operculate1446252operculate
opercules1345572opercules
operculum1552702operculum
opuscula1242792opuscula
specula11187422spe_cula
apercu1057383apercu__
apercus1136573apercu_s
fecula113310053_fe_cula
ferula93011173_fer_ula
furcula1245803_furcula
opera7313573oper___a
operable12410323operable
operably1557093operably
operceles1344613operceles
operculated1645153operculated
operculums1651913operculums
operetta1044303operetta
opuscular1343283opuscular
opuscule1242823opuscule
oscula837293o__scula
overcall1337673overcall
overcold14208493overcold
overcure132210053overcure
overcut12310423overcu_t
overcuts1337513overcuts
overfull1435923overfull
overrule11149673overrule
peculia1147133_pe_culia
percale11314093_percale
percuss1137163_percuss
pergola1067623_pergola
perilla9311233_perilla
specular12217623spe_cular
spicula11259303sp_icula
spirula9257703spir_ula
sterculia1152513sterculia

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 Filter1786911461620.423422437.4
2DLD Change Limit146162418.07618098.3
3Display Results41410.0162562.5
 (SQL Overall)178691418.51520985.4
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.