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

228 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
quinine16301104(None) 
quinin152811951quinin_
quinina16278141quinina
quinines172410201quinines
quinins162811291quinins
quinone16217461quinone
aquiline1746872aquiline
asinine7310722asinine
cuisine9310422cuisine
guanine8810542guanine
quinate16511572quinate
quince173910132quin_ce
quinic17319472quini_c
quinidine19154102quinidine
quininas17286032quininas
quinoline1845122quinoline
quinones17227752quinones
quinte153414522quin_te
quintile1736842quintile
quintin163810332quintin_
quintins17329862quintins
quiring17159992quiring
quoining1835892quoining
ruining83514882ruining
adenine8311213adenine
alanine7316863alanine
alining81917043alining
amidine103613853amidine
aniline7418473aniline
arginine948563arginine
brining103216473brining
burnie83715413burni_e
burning104215503burning
canine83826703_canine
chining133316843chining
chinone12510153chinone
coining103920543coining
coniine9316803coniine
conine84528553_conine
cotinine10311493cotinine
crimine112413473crimine
crinite9513633crinite
cuisines1049373cuisines
culicine1248343culicine
cunning104214623cunning
cutinise1048763cutinise
cutinize1948533cutinize
cutline92914543cutline
cyanine122911513cyanine
dining84525133_dining
divine103514463_divine
dunite7315013du_nite
dunning93514473dunning
dunnite857333dunnite
durning93511733durning
dwining12269293dwining
equine151711573equ__ine
equinity2045653equinity
eucaine939243eucaine
feminine13199783feminine
fining104223213_fining
finite9316823_finite
foining113013453foining
fulmine1257963fulmine
funning113813613funning
gaining94015663gaining
guanin7610803guanin_
guanines989773guanines
guanins8810013guanins
guiding102911843guiding
guiling93214213guiling
guising93511413guising
gumline102810113gumline
gunite7414403gu_nite
gunning93413173gunning
guyline11258173guyline
heinie92512663heini_e
hominine1348913hominine
hyenine1336953hyenine
imine75821063__imine
inane52820343__inane
inquiline1844753inquiline
intine61021983__intine
joining153011483joining
juicing1736883juicing
kainite1149543kainite
kinin94917323_kinin_
kinins104014583_kinins
leonine7311233leonine
linin58025523_linin_
lining74526803_lining
linins65922143_linins
lupine84013533lu_pine
mainline1039863mainline
meinie82614523meini_e
mining94225453_mining
murine84220023mu_rine
murrine9411483murrine
mutine84420373mu_tine
mutining11310493mutining
nine45842173___nine
olivine1038843olivine
opining10311743opining
oscinine1045533oscinine
outline72321333outline
paining103920243paining
peining104619153peining
pennine93712953pennine
pinene82915643_pinene
pining93726533_pining
pinite8321243_pinite
primine113214823primine
puisne856353pui_sne
punning103414993punning
purine85321893pu_rine
purline93516533purline
quailing1838403quailing
quaint15415173qu_aint
quaking2139313quaking
quantile1747323quantile
quanting1849233quanting
quantize2645963quantize
queening1846113queening
quercine1964863quercine
queuing1736233queuing
quibble2034713quibble
quiche2057903qui_che
quicken2235153quicken
quickie2235513quickie
quidnunc2051223quidnunc
quieten16258103quieten
quieting18228463quieting
quilling182510003quilling
quilting18218713quilting
quin135823923qu__in_
quinacrine2151853quinacrine
quinary1936933quinary
quinces183210433quinces
quincunx2641873quincunx
quinela1635203quinela
quinidines20133393quinidines
quiniela1743013quiniela
quinnat16116823quinnat
quinoa15377653quin_oa
quinoas16337873quinoas
quinoid1737353quinoid
quinoids1845693quinoids
quinol15357973quin_ol
quinolin1744593quinolin_
quinolines1964703quinolines
quinolins1844793quinolins
quinolone1862983quinolone
quinols16297243quinols
quins144819853qu__ins
quinsied1845043quinsied
quinsies1737623quinsies
quinsy18386353quin_sy
quint144529903qu__int
quinta153312373quin_ta
quintain17316223quintain_
quintains18306033quintains
quintal16389883quintal
quintan16399223quintan
quintans17337873quintans
quintar16478603quintar
quintas163611713quintas
quintes164114713quintes
quintet163914453quintet
quintic18308883quintic
quintics19266983quintics
quintiles1845983quintiles
quints154316563quin_ts
quipping2234843quipping
quire144917123qu__ire
quirking22215123quirking
quirting18238383quirting
quisling18218063quisling
quite144621463qu__ite
quitting18228833quitting
quixote2343423quixote
quizzing2643403quizzing
quoin144012323qu_oin_
quoined1735783qu_oined
quoins154110583qu_oins
quoiting1836093quoiting
quoting17310043quoting
raining83922693raining
reining84425323reining
ruinate7312833ruinate
running83514593running
rusine63916593ru_sine
saining83621393saining
seining84020773seining
sequining1945323sequining
shining113816523shining
squinnied1942673squinnied
squinnier1843033squinnier
squinnies1844483squinnies
squinny19274213squin_ny
squinting1936223squinting
squiring18177553squiring
stanine73417073stanine
stibine938663stibine
subline9316893subline
suicide1038893suicide
suiting83419003suiting
sunning83715673sunning
supine84216693su_pine
thionine1187923thionine
tining74927543_tining
trining82919213trining
tuning74016843tu_ning
tunning83514453tunning
turbine9310303turbine
turdine8310283turdine
turning83713183turning
twining113211443twining
undine7817263_undine
unite54828383_u_nite
uridine81311213uridine
urine55026593_u_rine
ursine64114123_ursine
veining114713893veining
venine93718433_venine
vining104619463_vining
vulpine1235903vulpine
whining143311673whining
wining103625053_wining

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.1561145455.1
2DLD Change Limit1340272287.42018062.9
3Display Results2282280.0802850.0
 (SQL Overall)1786912287.65623340.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.