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

85 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
optioned114638(None) 
optionee1046511optionee
captioned1445762captioned
motioned1137452motioned
opined95113852op_i_ned
opinioned1243272opinioned
option83612712option__
optional1047642optional
optionees1144342optionees
options93810602option_s
portioned1248332portioned
rationed9410092rationed
actioner1048663actioner
aproned10311503ap_roned
atoned75417543_at_oned
auctioned1244953auctioned
bastioned1246863bastioned
buttoned1137503buttoned
cautioned1245363cautioned
cottoned1138033cottoned
intoned8811993int_oned
lesioned936903lesioned
mentioned1246833mentioned
motioner1037593motioner
mutined103311353muti_ned
obtained1136533obtained
opened94311863op__ened
opiated1039483op_iated
opine77422463op_i_ne_
opines84820703op_i_nes
opioid9310083op_io_id
opposed1236123op_posed
oppugned1441583oppugned
opted84914273opt___ed
optime1079353opti_me_
optimes1148473opti_mes
optimised1444313optimised
optimized2344963optimized
opting94514403opti_n_g
optionals1145343optionals
optioning1246553optioning
ostiole739013ostiole_
ostioles839273ostioles
otiose639403o_tiose_
outboxed1836873outboxed
outdone8311643outdone_
outfoxed1936013outfoxed
outgone8311463outgone_
outlined92512953outlined
outloved12248583outloved
outmoded12207703outmoded
outmoved14247283outmoved
outrowed1239433outrowed
outsinned1045673outsinned
outvoted1237273outvoted
pained95622853_pai_ned
patined105114783pati_ned
peined94918843_pei_ned
petioled1137993petioled
phoned124014553_p_honed
pined85935323_p_i_ned
pinioned1137513pinioned
pinned94818383_p_inned
poisoned1136953poisoned
portioner1158683portioner
positioned1396003positioned
postponed1445903postponed
potholed1448393potholed
potion84519573potion__
potions93417423potion_s
prisoned1138813_prisoned
ratooned977103ratooned
sectioned1246523sectioned
spined95423943sp_i_ned
splined105013113spli_ned
spooned103412443sp_ooned
stationed1046143stationed
stoned75923143_st_oned
suctioned1245283suctioned
tined65434533__ti_ned
tinned74317533__tinned
toned65435343__t_oned
uptilted1174683uptilted
upturned11214013upturned
visioned1247013visioned

Search took 8 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.453394461.4
2DLD Change Limit146162856.53322372.9
3Display Results85850.0302833.3
 (SQL Overall)178691857.01625469.1
 
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.