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

84 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
orifice124634(None) 
orifices1346481orifices
artifice1346402artifice
edifice1344932edifice
office1435692o_ffice
orrice81410162or_rice
artificer1444023artificer
artifices1446483artifices
biface1358103_biface
boniface1543863boniface
cilice103213353_cilice
cornice11612933cor_nice
crevice1436153crevice
crimine112413473crimine
crinite9513643crinite
crisic103611843crisic_
critic103616813critic_
critics112811093critics
deific1237313deific_
dormice1237133dor_mice
edifices1454863edifices
fice95737123___fice
foreface1647113foreface
griffe13438093grif_fe
grimace1255083grimace
horrific1643623horrific_
iridic9328743iridic_
iritic83213823iritic_
morbific1743183morbific_
mortice11711493mor_tice
motific1446323motific_
noritic91213543noritic_
officer1534213o_fficer
offices1536243o_ffices
olefine1038023olefine
olivine1038843olivine
omnific1443813omnific_
oreide7311673or_eide
orgic8311823or_gic_
oribi7311093oribi__
oribis838833oribi_s
orificial1444373orificial
origin7311033origi_n
origins8310463origins
oriole6814293ori_ole
oroide7311703or_oide
orphic1368323orphic_
orpine83914483or_pine
orrices9129363or_rices
ossific1243103ossific_
otitic83112683otitic_
outface123011973outface
outfire1049713outfire
ovicide1346433ovicide
oxidic1635943oxidic_
oxidise1545043oxidise
oxidize2444983oxidize
preface14510923preface
prefile123413183prefile
prefire124012813prefire
price93725413pr__ice
primine113214823primine
prince104114763pri_nce
profile123211153profile
reface113616353_reface
refile95122373_refile
refine95225693_refine
refire95419473_refire
rice64942923_r__ice
rife74632333_rif__e
riffle124210233_riffle
rifle85518333_rif_le
rimfire1243793_rimfire
roofie93411173roofi_e
sacrifice16134533sacrifice
soricine10710883soricine
soritic91414433soritic_
suffice15197573suffice
trice75127493tr__ice
trifid1039063trifi_d
trifle94012883trif_le
uniface1236953uniface
unific1137463unific_
uridine81311213uridine

Search took 7 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.390458182.1
2DLD Change Limit134027846.20621596.4
3Display Results84840.0302800.0
 (SQL Overall)178691846.62626968.2
 
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.