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

124 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
opioids103652(None) 
opioid9310081opioid_
gobioids1243872gobioids
lipoids1038232lipoids
ovoids10456922o_voids
aphids125110843ap_hids
apods86316343ap_o_ds
aroids75118223_aroids
avoids104410203_avoids
bipods11408593bipo_ds
ceboids1237653ceboids
chorioids1545693chorioids
coccoids12176803coccoids
colloids11310173colloids
conoids10813883conoids
copious11311963copio_us
cricoids1347193cricoids
crinoids1147383crinoids
cuboids1236723cuboids
dioxids1655683_dioxids
diploids1247843diploids
droids84712583_droids
ephods1238363epho_ds
euploids1157243euploids
fiords10498623_fiords
fucoids1335663fucoids
gadoids1036873gadoids
ganoids939333ganoids
geoids8369843_geoids
gobioid1146023gobioid_
haloids113012553haloids
haploids1437363haploids
hominids14297363hominids
hominoids1544693hominoids
hoptoads1444143hoptoads
hyoids1377673_hyoids
imids86015153__imids
iodids83711153__iodids
irids66417783__irids
keloids1288663keloids
lipids94310923_lipids
lipoid9411043lipoid_
loids66220713__loids
meloids10911453meloids
mucoids1237423mucoids
odious749933odio_us
ogdoads1042993ogdoads
oidioid946053oidioid_
olios54520853olio__s
onions64016433onio_ns
onloads8246673onloads
ootids71110353o_otids
ophiuroids16121423ophiuroids
opiates9312143opiates
opined95113853opined_
opines84820703opi_nes
opining10311753opining
opinion946793opinion
opinions1045933opinions
opiums10307073opi_ums
opposes1149243opposes
opsins8411713op_sins
opsonins1045533opsonins
optics102810183op_tics
options93810603optio_ns
orchids1377213orchids
oribis838833oribi_s
origins8310463origins
orioles7412993orioles
oroide7311703o_roide
oroides8311973o_roides
osteoids945963osteoids
otitides937293otitides
otitis63612343otiti_s
outbids1098913outbids
ovicide1346433ovicide
ovicides1445463ovicides
ovoid94811023o_void_
oxfords1842893oxfords
oxids13128973o__xids
ozalids1794063ozalids
pikis115116393_piki_s
pilis75825203_pili_s
pions75826393_pio_ns
pious74621273_pio_us
pipits104713063_pipits
pities83828083_pities
pixies154915513_pixies
plaids94312443_plaids
plods85719293_plo_ds
ploidy1237483_ploidy
pods76540163_p_o_ds
poinds93511143poi_nds
pois66539043_p_oi_s
ponds85323403_p_onds
pongids11347413pongids
poods85124753_p_oods
prods85523553_pro_ds
psocids1234863_psocids
pyoid11513763_pyoid_
quinoids1845693quinoids
rhizoids2143463rhizoids
saiyids11174893saiyids
sloids73712693_sloids
sparids103512123sparids
sparoids11218713sparoids
spirits94112623spirits
spiroid10219823spiroid_
spoils84614533sp_oils
teiids736693tei_ids
topsoils1095143topsoils
toroids8310653toroids
toxoids1535213toxoids
trioxids1644443trioxids
typhoids1745493typhoids
upboils1184703upboils
upcoils1184933upcoils
upfolds13133753upfolds
upholds13135243upholds
uploads10266503uploads
viroids1137923viroids
voids95414683__voids
xiphoids2144193xiphoids
zooids1637093_zooids

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.406440125.6
2DLD Change Limit1340271246.15621771.8
3Display Results1241240.0462695.7
 (SQL Overall)1786911246.60827041.6
 
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.