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

58 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
opacify174365(None) 
opacity1436311opacity
pacify1667471_pacify
repacify1843482repacify
specify1764992specify
acidy117214893__acidy
basify1437513_basify
beatify1536593beatify
calcify1735873calcify
capacity1746023capacity
clarify1536093clarify
coalify1536683coalify
copurify1843053copurify
crucify1744063crucify
dulcify1643023dulcify
edacity1336373edacity
fancify1834983fancify
gasify1336333_gasify
gratify1436113gratify
lacily11612763_lacily
nazify2134233_nazify
opacified1744393opacified
opacifier1643623opacifier
opacifies1645463opacifies
opacifying2143363opacifying
opaline9412483opaline
opsonify1642273opsonify
orality101111683orality
ossify1244973o_ssify
outcity1238453outcity
ovality1377593ovality
pacey126720283_pac_ey
pacier105018683_pacier
pacific1646913_pacific
pacing114522753_pacing
packly17228333_packly
pacy115328683_pac__y
parity114719873_parity
paucity1435823_paucity
poachy16388963poac_hy
purify14399153_purify
qualify2235473qualify
racily11715173_racily
ramify14268753_ramify
rapacity1544983rapacity
rarify123210063_rarify
ratify122610043_ratify
salify12311373_salify
scarify1537443scarify
spacey136212533spac_ey
spacial1138763spacial
spacier114011633spacier
spacing123614493spacing
spacy125415623spac__y
spicily1438653spicily
tackify1934493_tackify
voracity1645533voracity
zincify2443913zincify

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 Filter1786911340270.470380193.6
2DLD Change Limit134027588.73615341.9
3Display Results58580.0461260.9
 (SQL Overall)178691589.25219313.8
 
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.