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

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

80 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
opined9511385(None) 
opened94311861opened
opine77422461opine_
opines84820701opines
pined85935321_pined
spined95423941spined
alined75221402alined
brined95118412brined
chined125620062chined
coined94523602coined
copied114618562copi_ed
dined76431992_dined
dwined114610212dwined
fined94930502_fined
foined105915012foined
gained84617462gained
joined144613072joined
lined64934642_lined
mined85333352_mined
oiled64429472o_iled
oinked114213282o_inked
omened93711002omened
oped76230152op__ed
opener83910992opener
opiated1039482opiated
oping86322412opin_g
opioid9310082opioid
opted84914272op_ted
optioned1146382optioned
orpine83914482orpine_
orpines94414792orpines
ovine86316642ovine_
ovines94614342ovines
owned95113232o_wned
pained95622852pained
paned85437182_paned
peined94918842peined
pied75035362_pi_ed
piked125623312_piked
piled85232992_piled
pine67755712_pine_
pines76048862_pines
piney105727502_piney
pinged104321382_pinged
pinked134819882_pinked
pinned94818382_pinned
piped105123162_piped
poind84217912poin_d
poinded11358972poinded
pointed103813982pointed
poised94918472poised
ponied94920702ponied
propined133111502propined
rained75024602rained
reined74425522reined
repined104918772repined
rosined84911902rosined
ruined74813322ruined
sained75424242sained
seined74023062seined
shined104620782shined
sopited104211062sopited
spiced115218312spiced
spied85427712spi_ed
spiked134915552spiked
spiled94621992spiled
spine76534422spine_
spinel85317332spinel
spines85132032spines
spinet85629752spinet
spired94921862spired
spited94820442spited
splined105013112splined
tined65434532_tined
trined74920712trined
twined104413122twined
veined104413912veined
vined95626152_vined
whined134715202whined
wined94434182_wined

Search took 4 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 Filter178691825510.356501941.0
2DLD Change Limit82551802.70330540.5
3Display Results80800.0165000.0
 (SQL Overall)178691803.07558110.9
 
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.