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

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

57 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
officinals185253(None) 
officials1743401offici_als
officinal1743541officinal_
official1644892offici_al_
officiants1853422officiants
medicinals1543143medicinals
officialese1961493offici_alese
officialism2152573offici_alism
officially2143453officially
officiant1745063offici_ant
officiary2052323offici_ary
officiate1744163offici_ate
officiates1843693officiates
officious1763873offici_ous
originals1044843o_riginals
afficionado20191394afficionado
afficionados21181224afficionados
affinal1336444aff__inal_
affixial2143594affixi_al_
criminals1346294_criminals
efficiently2252934efficiently
effigial1542834effigi_al_
facials123310744__faci_als
fecials123510334__feci_als
ficins113513984__ficin__s
finals94316164__f__inals
finials103210154__fini_als
medicinal1445084medicinal_
municipals1652434municipals
nonofficials2061984nonoffici_als
occipitals1652084occipitals
offals1235894off____als
offerings1643654offerin_gs
officers1643804offic__ers
offices1536244offic___es
officialdom2261084offici_aldom
officialdoms237844offici_aldoms
officialeses2061144offici_aleses
officialisms2262314offici_alisms
officiaries1952504officiaries
officiated1943254officiated
officiously2254214officiously
offings14285834off__in_gs
offishness1943794offishness
offprints1742444offprin_ts
oiticicas1353304oiticica_s
opticians1345544optici_ans
optionals1145344opti_onals
orcinols1044414o__rcinols
ordinals946754o__rdinals
orificial1444374orifici_al_
original956794o_riginal_
ovicidal1443924o_vicidal_
semifinals1553224semifinals
unofficial1852474unoffici_al_
vaticinal1444574vaticinal_
vicinal12268544__vicinal_

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 Filter1786911614500.420425454.8
2DLD Change Limit161450579.42317133.6
3Display Results57570.0301900.0
 (SQL Overall)178691579.87318099.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.