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

187 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
heinous103885(None) 
acinous9310922acinous
heinies102514542heinies
heinously1544772heinously
ominous949022ominous
resinous838502resinous
ruinous739752ruinous
spinous9310442spinous
urinous7310082urinous
venous93713192ve_nous
vinous93914172_vinous
acinus8311253acin_us
adipous1037183adipous
aeneous739893aeneous
aeneus61111143ae_neus
anginous947643anginous
arenous7314183arenous
beanos85516513beano_s
beings94613033bein_gs
beknots1335083beknots
besnows1245153besnows
bijous1548043_bijous
binocs1039923_binocs
burnous938823burnous
census84310303ce_nsus
cernuous1055013cernuous
cerous85821203ce_rous
chinos115018693chino_s
chitinous1474983chitinous
cretinous1145893cretinous
desirous947783desirous
devious1138523devious
dingus83611843_dingus
dinos65428063_dino_s
eidos65817753_eido_s
eikons1038503_eikons
enginous946493enginous
enols54718403_e_nols
enows85115493_e_nows
feijoas1742323feijoas
feints94813873fein_ts
ferrous1049793ferrous
finos86226953_fino_s
genius74512923ge_nius
genoas74013623ge_noas
genoms94412483ge_noms
genus65319833ge_n_us
haikus13538293hai_kus
haints94417583hain_ts
hectors123513263hectors
heifers1337933heifers
heights14399443heights
heils85222193hei__ls
heinie92512663hein_ie
heirdoms1444353heirdoms
heiress1036813heiress
heirs85618563hei__rs
heists96814633hei_sts
helicons1337613helicons
helios94816633helio_s
helloes103717453helloes
hellos95321683hello_s
helos84928063he_lo_s
helots95217703he_lots
hemins113417563hemin__s
henges104516453he_nges
henhouse1445573henhouse
hennas94211803he_nnas
henrys12366103he_nrys
hens75642573he_n__s
hents87330743he_n_ts
heriots10312063heriots
heritors11310903heritors
hernias10310773hernias
herns84825583hern__s
heroes94923823he_roes
herons94820543he_rons
heros84930863he_ro_s
hexones17299143hexones
hiatus938223h_iatus
hideous1168433hideous
hilus84817643h_i_lus
hinds96721473h_in_ds
hinges105121023h_inges
hins76447993h_in__s
hints87330623h_in_ts
hobnobs1443603hobnobs
honors94816793h_onors
honour94710863h_onour
honours10339353h_onours
hugeous1137133hugeous
hydrous14197883hydrous
incus73315053__incus
jealous1438093jealous
kenos95220623ke_no_s
kinos96626143_kino_s
laminous1037943laminous
lenos56024863le_no_s
leprous938843leprous
linos55631503_lino_s
luminous1037113luminous
meinies92516073meinies
melanous1048603melanous
menus75822843me_n_us
meous76120063me__ous
merinos9311973merino_s
miaous8511693_miaous
minors85117093_minors
minus75223933_min_us
mucinous1245373mucinous
mutinous1047653mutinous
nervous1037143nervous
ninons64913773_ninons
nous46136983___nous
numinous1046293numinous
odious749933odi_ous
ozonous1645263ozonous
pectinous1345543pectinous
peins76128063pein__s
pennons939713pennons
pepinos1137693pepino_s
perilous10310683perilous
pernods1038483pernods
petrous92714423petrous
phenols1238103phe_nols
phenoms1437813phe_noms
pilous84717753_pilous
pinons86019943_pinons
pinots85920273_pinots
pious74621273_pi_ous
quinoas16337873quinoas
quinols16297243quinols
rainout7314393rainout
rainouts846913rainouts
reincur945133reincur
reincurs1045543reincurs
reinfuse1144783reinfuse
reinks105012153rein_ks
reins56234563rein__s
reknots1136783reknots
retinols8419743retinols
rhinos94411123rhino_s
rimous8311913_rimous
rosinous847363rosinous
sanious7514103sanious
segnos73610443segno_s
seiners74219273seiners
seines65029903sein_es
seisors73212813seisors
seizors16328993seizors
selenous848973selenous
seniors73413613seniors
senors63620783se_nors
serious73616283serious
serous65023563se_rous
setous64917373se_tous
sinuous739063_sinuous
sinus55523853_sin_us
spinors939413spinors
spinout9311583spinout
spinouts1036023spinouts
tedious838443tedious
teinds738263tein_ds
tendinous1044623tendinous
tendus75111183te_ndus
tenons62916603te_nons
tenors63217753te_nors
tenour62610733te_nour
tenours72610053te_nours
tenuous738473tenuous
theines104013233thein_es
theins95015423thein__s
uranous7310723uranous
veiners104112523veiners
veins84620493vein__s
venoms114211213ve_noms
venus84918903ve_n_us
verminous1445573verminous
vinos84723073_vino_s
weiners103913063weiners
winoes94317013_winoes
winos84625043_wino_s
xenons132710483xe_nons
xenopus1642983xe_nopus
zealous1637813zealous
zeins144715393zein__s
zincous1837053_zincous

Search took 9 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.1561145455.1
2DLD Change Limit1340271877.87317023.6
3Display Results1871870.0802337.5
 (SQL Overall)1786911878.10922036.1
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.