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

138 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
quinary193693(None) 
binary11312222_binary
culinary1355852culinary
luminary13336652luminary
quandary2143432quandary
quinate16511572quinate
quinsy18386352quin_sy
quintar16478602quintar_
quintars17337562quintars
quivery22265462quivery
trinary1039172trinary
unary8315992_u_nary
urinary1037242urinary
acinar8310483acinar_
apiary113910383api_ary
ariary94114203ari_ary
aviary12338413avi_ary
briary114912003bri_ary
bursary12397583bursary
canary11314693_canary
denary105316863_denary
diary95016973_di_ary
dinar66319893_dinar_
dinars75417563_dinars
equinely2044643equinely
equinity2045653equinity
finery124512893_finery
friary124010093fri_ary
granary1157793granary
guanay1037913guana_y
guisard954203guisard
guitar7117443guitar_
guitars8116863guitars
gunnery11376373gunnery
gurnard944773gurnard
hungry1334973hu_ngry
hymnary1843033hymnary
inarm7314423__inarm
joinery17366593joinery
kinara10310373_kinara
laminary13337253laminary
laniary1068013laniary
lunacy1136843lu_nacy
lunar57017313lu_nar_
lunars65012813lu_nars
nary76931223___nary
nummary14314653nummary
nunnery10355303nunnery
olivary1345163olivary
ordinary1244913ordinary
pinery115214293_pinery
plenary1237543plenary
primary1437703primary
pupilary15104123pupilary
qindar16317173q_indar_
qindars17267423q_indars
qintar15359143q_intar_
qintars16268573q_intars
quaintly2065023quaintly
quaky214310743qu__aky
quare143920543qu__are
quark184614123qu__ark
quarry1837473qu_arry
quart144027853qu__art
quasar1536833quasar_
quasars1646903quasars
quavery22225483quavery
quay164618353qu__a_y
queasy1855173qu_easy
queazy2743573qu_eazy
query174212083qu__ery
quickly2534073quickly
quietly1945893quietly
quin135823923quin___
quinaries1857873quinaries
quince173910133quin_ce
quinces183210433quinces
quinela1635213quinela
quinic17319473quin_ic
quinin152811953quin_in
quinina16278143quinina
quinine163011043quinine
quinins162811293quinins
quinnat16116823quinnat
quinnats17124283quinnats
quinoa15377653quin_oa
quinoas16337873quinoas
quinoid1737353quinoid
quinol15357973quin_ol
quinols16297243quinols
quinone16217463quinone
quins144819853quin__s
quint144529903quin__t
quinta153312373quin_ta
quintain17316223quintain
quintal16389883quintal
quintals17288003quintals
quintan16399223quintan
quintans17337873quintans
quintas163611713quintas
quinte153414523quin_te
quintes164114713quintes
quintet163914453quintet
quintic18308883quintic
quintin163810333quintin
quints154316563quin_ts
quippy22384263qui_ppy
quire144917133qui__re
quirk184011003qui__rk
quirky22435533qui_rky
quirt144624233qui__rt
quiver18278743quiver_
quivers19298753quivers
quixotry2741403quixotry
ruinate7312833ruinate
ruiner64013643ruiner_
ruiners74213023ruiners
seminary1398093seminary
senary93716073_senary
squinny19274223squin_ny
squinty19287063squin_ty
sudary1038703su_dary
sugary1039013su_gary
summary14297353summary
sundry1057943su_ndry
sunray9310123su_nray
ternary1038343ternary
turbary1236383turbary
turnery10357423turnery
ulnar56013983_ulnar_
unarm7314453_u_narm
unitary1038613unitary
unwary1239823_unwary
vinery124912603_vinery
vivary1536983_vivary
winery125014283_winery
wintry12498923_wintry
zonary1838793_zonary

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 Limit1340271385.81323056.4
3Display Results1381380.0463000.0
 (SQL Overall)1786911386.26528522.1
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2025  |  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.