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

197 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
quinol1535797(None) 
quinoa15377651quinoa
quinols16297241quinols
equinox2343012equinox
quill148413762qui_ll
quin135823922quin__
quince173910132quince
quinela1635202quinela
quinic17319472quinic
quinin152811952quinin
quinoas16337872quinoas
quinoid1737352quinoid
quinolin1744592quinolin
quinone16217462quinone
quins144819852quin_s
quinsy18386352quinsy
quint144529902quin_t
quinta153312372quinta
quintal16389882quintal
quinte153414522quinte
quints154316562quints
amidol9489563amidol
amino75425493amino_
binal75323823_binal
bunion83111313bunion
butanol945433butanol
chino105823313chino_
chinos115018693chinos
cibol9512023_cibol
cineol8108203_cineol
clinal8311553clinal
cuing85420193cuin_g
dino56036753_dino_
dinos65428063_dinos
diol57329133_di_ol
enol45823823__enol
equine151711573equin_e
equinely2044633equinely
equines161811593equines
eugenol844623eugenol
final83922033_final
fino76034693_fino_
finos86226953_finos
frijol1634123frijol
frivol1235113frivol
funnel93610743funnel
guano69213983guano_
guanos73811993guanos
guenon736403guenon
guidon837373guidon
guinea737613guinea
guiro63712093guiro_
guiros7389093guiros
gunnel73411053gunnel
huipil1143773huipil
idol56818633__idol
imino74315213imino_
indol63714873__indol
junior1386143junior
kino86233613_kino_
kinos96626143_kinos
lino46343373_lino_
linos55631503_linos
lintol6369473_lintol
luminal93711003luminal
minor74920063_minor
nicol71113293_nicol
ninon55517383_ninon
nitinol745143nitinol
orcinol944703orcinol
phenol1149253phenol
pinole83218783_pinole
pinon76024533_pinon
pinot78737293_pinot
quahog1944103quahog
quail144314363qu_ail
quaint15415173quain_t
quaintly2065023quaintly
quango1636493quango
quangos1734653quangos
quant143624813quan_t
quanta153911333quanta
quantal16367893quantal
quants153614143quants
quell144311423qu_ell
quench2036633quench
quezal2435143quezal
quibble2034713quibble
quiche2057903quiche
quick204311063qui_ck
quickly2534063quickly
quicks21389303quicks
quid144922353qui__d
quids154917463qui_ds
quiet144530733qui_et
quietly1945883quietly
quiets154014373quiets
quiff201111553qui_ff
quiffs21135433quiffs
quills153811843quills
quilt144125103qui_lt
quilts154112543quilts
quinary1936933quinary
quinate16511573quinate
quinces183210433quinces
quinelas1744923quinelas
quinella1744033quinella
quiniela1743013quiniela
quinina16278143quinina
quinine163011043quinine
quinins162811293quinins
quinnat16116823quinnat
quinoidal1943203quinoidal
quinoids1845683quinoids
quinoline1845123quinoline
quinolins1844793quinolins
quinolone1862983quinolone
quinones17227753quinones
quintals17288003quintals
quintan16399223quintan
quintar16478603quintar
quintas163611713quintas
quintes164114713quintes
quintet163914453quintet
quintic18308883quintic
quintile1736843quintile
quintin163810333quintin
quip154818623qui__p
quippu19344863quippu
quippy22384263quippy
quips164713373qui_ps
quipu164811643qui_pu
quipus17458003quipus
quire144917123qui_re
quired163711943quired
quires154015733quires
quirk184011003qui_rk
quirks19419113quirks
quirky22435523quirky
quirt144624233qui_rt
quirts154213553quirts
quit136136513qui__t
quitch2036413quitch
quite144621463qui_te
quits144122353qui_ts
quittor16285603quittor
quiver18278743quiver
quixote2343423quixote
quiz224920003qui__z
quod145413623qu__od
quohog1942503quohog
quoin144012323quoin__
quoined1735783quoined
quoins154110583quoin_s
quoll14379493qu_oll
retinol7469693retinol
rhinal9510183rhinal
rhino84614323rhino_
rhinos94411123rhinos
rosinol756323rosinol
ruin47430513ruin__
ruined74813323ruined
ruiner64013643ruiner
ruing67221053ruin_g
ruinous739753ruinous
ruins55822033ruin_s
ruminal9289993ruminal
runnel63510663runnel
spinal84915313spinal
spinel85317333spinel
spinor839943spinor
squill1537223squi_ll
squinch2134833squinch
squinny19274213squinny
squint154214793squin_t
squints16339033squints
squinty19287053squinty
stanol6310723stanol
suing65026363suin_g
suint55638183suin_t
suints64617783suints
suitor63311053suitor
thiol87616043thi_ol
trinal6516953trinal
triol55521363tri_ol
tunnel64310633tunnel
turnon638193turnon
union54519793_union
urinal6614123urinal
veinal93812963veinal
vinal85725813_vinal
vino76128433_vino_
vinos84723073_vinos
vinyl115311623_vinyl
viol76523593_vi_ol
wino75933613_wino_
winos84625043_winos

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 Filter1786911127160.1401276364.3
2DLD Change Limit1127161977.62614780.5
3Display Results1971970.0603283.3
 (SQL Overall)1786911977.82622833.0
 
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.