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

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

101 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
opinions104593(None) 
opinion946791opinion_
pinions93413601_pinions
dominions12126552dominions
inions64417002__inions
minions93314622_minions
onions64016432o__nions
opining10311742opini_ng
opinioned1243272opinioned
options93810602op_tions
pinion83815892_pinion_
pinons86019942_pin_ons
pinyons12299002_pinyons
amnions93710913_amnions
anions64123033__anions
bunions92210473_bunions
coitions10312853coitions
companions1697263companions
dominion11147033dominion_
editions9310403editions
elisions82210423elisions
epigons1048183epi_gons
epinaos936283epinao_s
fanions103713073_fanions
grunions945353grunions
hominians1445913hominians
inion54620183__inion_
kinins104014583_kini_ns
linins65922143_lini_ns
minion83416243_minion_
monitions11310883monitions
munnions1035273munnions
ninons64913773_nin_ons
nonunions945583nonunions
oblivions1443243oblivions
olingos846013olingo_s
omicrons1275193omicrons
omikrons1462963omikrons
ominous949033omin_ous
omissions1146153omissions
onion54320973o__nion_
oniony9369703o__niony
opening1039923openi_ng
openings1134803openings
operons91411743op_erons
ophidians1543023ophidians
opines84820703opin__es
opioids1036523opioi_ds
opsins8411713op_si_ns
opsonins1045533opsoni_ns
opticians1345543opticians
option83612713op_tion_
orations81515803orations
origins8310463origi_ns
orisons7310563ori_sons
ovations11149263ovations
pennons939713_pennons
pensions10311693_pensions
pigeons1039183_pigeons
pillions101610923_pillions
pinbone1138183_pinbone
pinbones1238143_pinbones
pingoes105116523_pingoes
pingos95317673_pingo_s
pining93726533_pini_ng
pinioned1137513_pinioned
pinites9319533_pinites
pinitols1046103_pinitols
pinkens13419643_pinkens
pinkoes135512313_pinkoes
pinkos125313873_pinko_s
pinon76024533_pin_on_
pinones94717073_pin_ones
pinots85920273_pin_ots
pintoes95117713_pintoes
pintos86021293_pinto_s
pinyon11459763_pinyon_
pions75826393_p__ions
pistons93016373_pistons
pitons85319043_pi_tons
poisons9310353poi_sons
pontons93315553_pontons
portions10514413portions
positions11811503positions
potions93417423_potions
prions84317783_p_rions
quinins162811293quini_ns
reunions837273reunions
ronions73313343_ronions
spinors939423spin_ors
spinous9310443spin_ous
spintos939133spinto_s
sponsions1145223sponsions
sponsons1045813sponsons
ternions838813ternions
tuitions838283tuitions
unions64216753__unions
virions1039873_virions
visions10311023_visions
volitions1288663volitions
wanions104011373_wanions

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.423422437.4
2DLD Change Limit1461621016.87321266.1
3Display Results1011010.0333060.6
 (SQL Overall)1786911017.32924381.4
 
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.