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

200 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
ruinous73976(None) 
urinous7310081urinous
acinous9310932acinous
burnous938822burnous
heinous1038852heinous
luminous1037112luminous
mucinous1245372mucinous
mutinous1047652mutinous
numinous1046292numinous
ominous949032ominous
quinoas16337872quinoas
quinols16297242quinols
rainout7314392rainout
rainouts846922rainouts
resinous838502resinous
rhinos94411122rhino_s
rimous8311912r_imous
rosinous847372rosinous
rubious938282rubious
rufous948272ru_fous
rugous739652ru_gous
ruiners74213022ruiners
ruinously1245732ruinously
ruins55822032ruin__s
runout6414872ru_nout
runouts737352ru_nouts
spinous9310442spinous
uranous7310732uranous
vinous93914172_vinous
acinus8311253acin_us
acuminous1344013acuminous
adipous1037183adipous
aluminous1145293aluminous
anginous947643anginous
arenous7314183arenous
arsenous847533arsenous
arsonous846393arsonous
aurous64119263au_rous
bijous1548043_bijous
binocs1039923_binocs
bruins86014953bruin__s
brumous11107443bru_mous
bulbous1138293bulbous
bullous9311663bullous
bunions92210473bunions
burnout9310453burnout
burnouts1045263burnouts
ceruminous1443193ceruminous
chinos115018693chino_s
cretinous1145893cretinous
criminous1375323criminous
cuprous1149743cuprous
curious93813563curious
dingus83611843_dingus
dinos65428063_dino_s
dubious1036893dubious
duteous838453duteous
enginous946493enginous
finos86226953_fino_s
fucous11399863fu_cous
fulvous1334543fulvous
fundus10429173fu_ndus
fungous11367433fungous
fungus10418183fu_ngus
furious103110633furious
fuscous1256673fuscous
glutinous1044463glutinous
grumous1086613gru_mous
grunions945353grunions
guanos73811993guano_s
guenons836563guenons
guidons936623guidons
guineas836753guineas
guiros7389093guiro_s
gummous1236263gummous
hugeous1137133hugeous
incus73315053__incus
juniors1475783juniors
kinos96626153_kino_s
laminous1037953laminous
linos55631503_lino_s
lupous849433lu_pous
luteous739273luteous
miaous8511693_miaous
minors85117103_minors
minus75223933_min_us
mucous104411653mu_cous
muticous1246933muticous
ninons64913773_ninons
nous46136983___nous
nubilous1044853nubilous
odious749933odi_ous
orcinols1044413orcinols
ozonous1645263ozonous
pilous84717753_pilous
pinons86019943_pinons
pinots85920273_pinots
pious74621273_pi_ous
pruinose1044853pruinose
prunus8399363pru_n_us
pulpous1177013pulpous
quietus16286393quietus
quinces183210433quinces
quinins162811293quinins
quinoa15377653quino_a
quinoid1737353quinoid
quinoids1845693quinoids
quinol15357973quino_l
quinone16217463quinone
quinones17227753quinones
quins144819853quin__s
quintas163611713quintas
quintes164114713quintes
quints154316563quin_ts
quippus20363543quippus
quipus17458003qui_pus
railbus934413railbus
rainbows1343243rainbows
rains55140233rain__s
ramous8417113r_amous
raucous938303raucous
ravenous1146793ravenous
reincur945133reincur
reincurs1045553reincurs
reinfuse1144783reinfuse
reinks105012153rein_ks
reins56234563rein__s
reknots1136783reknots
retinols8419743retinols
reunions837273reunions
rhino84614323rhino__
rhizopus2241833rhizopus
ricinus9408123ricin_us
rictus8379193r_ictus
rigors72813713r_igors
rigour7258023r_igour
rigours8207003r_igours
rinds64826153r_in_ds
rings65029173r_in_gs
rinks94827103r_in_ks
rins46153203r_in__s
rinses64720383r_inses
riotous739883riotous
riots54922013r_i_ots
risus54216393r_i_sus
ronions73313343ronions
rosinols845673rosinols
ruanas6311263ruan_as
rubigos1033653rubigo_s
rubout8313563ru_bout
rubouts937983ru_bouts
rubus76415063ru__bus
ruckus12407793ru_ckus
ructious10277083ructious
ruin47430513ruin___
ruinate7312833ruinate
ruinates8311883ruinates
ruined74813323ruin_ed
ruiner64013643ruin_er
ruing67221053ruin__g
ruining83514883ruining
rulings83310383rulin_gs
rumors81110403ru_mors
rumour8127383ru_mour
rumours976373ru_mours
rumpus10458893ru_mpus
runes55530223ru_n_es
rungs611819403ru_n_gs
runnels7329163runnels
runners74212453runners
runoff1235413ru_noff
runoffs1343013ru_noffs
runs46438083ru_n__s
runts55927633ru_n_ts
rutins63818393rutin__s
sanious7514103sanious
sinuous739063_sinuous
sinus55523853_sin_us
spinors939423spinors
spinout9311583spinout
spinouts1036023spinouts
suints64617783suin_ts
suitors73012493suitors
turnons737863turnons
turnout7410283turnout
turnouts845413turnouts
unaus53216573_u_naus
uncus74014983_u_ncus
unguinous1043603unguinous
unions64216753_unions
urinals7610263urinals
urines64724123urin_es
urinose738483urinose
uveous936603_uveous
venous93713193_venous
verminous1445573verminous
vinos84723073_vino_s
winoes94317013_winoes
winos84625043_wino_s
zincous1837053_zincous

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 Filter1786911340270.406440125.6
2DLD Change Limit1340272006.75019855.9
3Display Results2002000.0633174.6
 (SQL Overall)1786912007.21924752.9
 
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.