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

59 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
occlude126318(None) 
occluded1492591occluded
occludes1363101occludes
collude10337982collude
conclude1344662conclude
exclude1744452exclude
include1036082include
occludent1442292occludent
seclude1035232seclude
accede1138293acc_ede
accolade1346043accolade
accrue1035823accru_e
accrued1233823accrued
accuse103411033acc_use
allude73910903_allude
clade85821013__clade
clue65324533__clu_e
clued84917683__clued
cockade1638133cockade
collide103214783collide
colluded12296453colluded
colluder11276863colluder
colludes11279213colludes
colure8314153_colure
concluded1544023concluded
concluder1444173concluder
concludes1445133concludes
coude85022633__coude
crude86018573__crude
delude81910673_delude
elude64517623__elude
excluded1943433excluded
excluder1843453excluder
excludes1844383excludes
illude7327503_illude
included1234833included
includes1146023includes
lude55331643___lude
nuclide1037173nuclide
obtrude1044243obtrude
occluding1542823occluding
occlusal1242323occlusal
occlusive1643263occlusive
occult1038433occ_ult
occulted1344263occulted
occulter1244113occulter
occults1135123occults
occupy1543153occ_upy
occur9137323occ_u_r
occurs10136553occ_urs
oculus8178393oculu_s
oscule838193osc_ule
postlude1144543postlude
preclude1344903preclude
prelude1038013prelude
recluse95210773recluse
scalade10359263scalade
secluded1233663secluded
secludes1134953secludes

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 Filter1786911340270.1561145455.1
2DLD Change Limit134027598.26616214.3
3Display Results59590.0331787.9
 (SQL Overall)178691598.45521134.4
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.