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

314 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
quarry183746(None) 
burry105221562bu_rry
carry105823782_carry
charry145012112charry
curry105920342cu_rry
equerry1943042equerry
furry116719282fu_rry
gharry13546272gharry
gurry94515412gu_rry
harry115322952_harry
hurry114917182hu_rry
knarry1334612knarry
marry104821692_marry
murry105120232mu_rry
parry105323752_parry
quacky24376962quacky
quaere154110672quaere
quaggy2084682quaggy
quaky214310742qua_ky
qualmy20285802qualmy
quare143920542qua_re
quark184614122qua_rk
quarks193810912quarks
quarrel1636092quarrel
quart144027852qua_rt
quarte154115322quarte
quarto153511122quarto
quarts154715932quarts
quartz244212102quartz
quatre153512352quatre
quavery22225482quavery
quay164618352qua__y
query174212082qu_ery
quirky22435522quirky
scarry116311182scarry
sparry115111302sparry
starry94911672starry
tarry85422512_tarry
aery77231683__aery
airy75734153__airy
alary86123443ala_ry
aquaria1638033aquaria
army96624183__army
array86317143__array
arty77531313__arty
augury10366663augury
aurar54420253aurar_
autarky1444703autarky
awry107619683__awry
barky145721613_barky
barmy125218763_barmy
barny105821733_barny
barre75929543_barre
berry104521773_berry
blurry11437673blurry
burly104922833bu_rly
burr65631233bu_rr_
burro75018493bu_rro
burrs74925653bu_rrs
bury95633593bu__ry
carny105822923_carny
carr65434703_carr_
carrs75730853_carrs
charr104821783charr_
charro114212953charro
charrs115219183charrs
chary135023133cha_ry
cherry144810763cherry
clary105719613cla_ry
cuatro838413cuatro
curacy1339593curacy
curara83712203curara
curare84916953curare
curari84414403curari
curdy115916523cu_rdy
curly105321233cu_rly
curr65429653cu_rr_
currs75624393cu_rrs
curvy136013373cu_rvy
dairy97016303_dairy
darky136018833_darky
daubry12445483daubry
dearly104615323dearly
deary95826843dea_ry
derry94721373_derry
diary95016973dia_ry
dually103210063dually
dupery12378743dupery
durr55624353du_rr_
durra65315793du_rra
durrs65519993du_rrs
early85324123_early
equably2136183equably
equally1936863equally
faery116015483_faery
fairy115318283_fairy
farcy135217093_farcy
ferry116020803_ferry
firry115713533_firry
flurry12397113flurry
fury107727973fu__ry
furzy2010116063fu_rzy
gharri10386163gharri
glairy10448273glairy
glary96018543gla_ry
gnarly104610383gnarly
gnarr64810693gnarr_
gnarrs7407663gnarrs
guanay1037913guanay
guar56923293gua_r_
guard74415543gua_rd
guards84611563guards
guars65021043gua_rs
hairy115316833_hairy
hardy125622063_hardy
harpy136418203_harpy
hearty126313633hearty
herry114922473_herry
hoary114516763hoa_ry
horary12310383horary
hungry1334973hungry
hurly115819293hu_rly
hurray12459913hurray
jerry155016183_jerry
jury146719593ju__ry
kaury12429763_kaury
kerry124916093_kerry
lardy96119273_lardy
larky125218873_larky
leary85927383lea_ry
lorry86315673_lorry
luxury1642543luxury
marly106925613_marly
marvy135014033_marvy
merry104721483_merry
murky145216683mu_rky
murr65225133mu_rr_
murra74519083mu_rra
murre74821073mu_rre
murrey114312253murrey
murrs75521293mu_rrs
narky126017803_narky
nary76931223_na_ry
nearby11356053nearby
nearly94813733nearly
ourari63413543ourari
outcry1137993outcry
ovary1149113ova_ry
pardy115523953_pardy
parr65731153_parr_
parrs75928673_parrs
party106630613_party
pearly116414843pearly
perry105222713_perry
puggry13374823puggry
purr64925813pu_rr_
purrs75320433pu_rrs
pursy105016413pu_rsy
purty105019403pu_rty
qua124821973qua___
quack203812503qua_ck
quackery2633113quackery
quacks214710103quacks
quad144618703qua__d
quadrat1769273quadrat
quadric1946303quadric
quads154515843qua_ds
quaeres163310833quaeres
quaff201311353qua_ff
quaffs21125693quaffs
quag144815943qua__g
quagga1754143quagga
quagmiry2341723quagmiry
quags154613253qua_gs
quahog1944103quahog
quai134420393qua__i
quaich2047693quaich
quaigh1935463quaigh
quail144314363qua_il
quails153412643quails
quaint15415173quaint
quais144618393qua_is
quake184114643qua_ke
quaked203910033quaked
quaker193811623quaker
quakers20309683quakers
quakes194013343quakes
quakily2336693quakily
quale143617853qua_le
qualia1559563qualia
qualify2235473qualify
quality1938563quality
qualm163511183qua_lm
qualms17317243qualms
quandary2143433quandary
quango1636493quango
quant143624813qua_nt
quanta153911333quanta
quants153614143quants
quarrels1735073quarrels
quarried1836093quarried
quarrier1736843quarrier
quarries1749943quarries
quarrying2273733quarrying
quarryman2351973quarryman
quarrymen2352333quarrymen
quartan1636423quartan
quarter163211853quarter
quarterly2143693quarterly
quartern17286473quartern
quarters173110443quarters
quartes163314933quartes
quartet162814893quartet
quartic18258473quartic
quartos16328733quartos
quasar1536833quasar
quasars1646903quasars
quash174512163qua_sh
quasi144015023qua_si
quass144413763qua_ss
quate144521413qua_te
quatres163411923quatres
quaver18309313quaver
quavers19309003quavers
quays174612043qua_ys
queasy1855173queasy
queazy2743573queazy
queer143712813queer_
queerly1934223queerly
queers153510773queers
quern143610403qu_ern
querns15307943querns
quey164616473qu__ey
quinary1936933quinary
quinsy18386353quinsy
quippy22384263quippy
quire144917123qu_ire
quired163711943quired
quires154015733quires
quirk184011003qu_irk
quirks19419113quirks
quirt144624233qu_irt
quirts154213553quirts
quivery22265453quivery
quorum1736023quorum
qursh174110843qu_rsh
qwerty2133583qwerty
recarry1245063recarry
remarry1235193remarry
rudery10419033rudery
sarky125521783_sarky
saury84317223_saury
scarey115016983scarey
scary105222593sca_ry
scurry11419583scurry
serry84824123_serry
sharny124711833sharny
sharpy145211033sharpy
sherry124510413sherry
skerry13356103skerry
slurry9378593slurry
smarmy13629353smarmy
smarty115013793smarty
snarky134210843snarky
snarly93815003snarly
sorry84618253_sorry
sparky154511523sparky
spurry11429113spurry
squabby2343283squabby
squally1937663squally
square154513353squa_re
squared173610553squared
squarely2045343squarely
squarer163410653squarer
squarers17338003squarers
squares163714453squares
squark19438113squa_rk
squarks20417183squarks
squashy2233843squashy
squatly1946423squatly
squatty1964823squatty
squirmy21374283squirmy
suably112814533suably
suasory1046043suasory
sudary1038703sudary
sugary1039013sugary
sultry938463sultry
sundry1057943sundry
sunray9310123sunray
surfy115319473su_rfy
surgy95118523su_rgy
surly85124423su_rly
surra55521343su_rra
surrey94414573surrey
swarty125812383swarty
tardy94720463_tardy
tarre55825633_tarre
tarty86328183_tarty
teary85124053tea_ry
terry84721873_terry
turfy114315403tu_rfy
unary8315993_unary
updry1135483_updry
urare56322553_urare
urari54619963_urari
usury887623_usury
vary105226063_va_ry
warty119323823_warty
wary106740013_wa_ry
weary115620613wea_ry
wherry15477333wherry
whirry15477063whirry
worry116114333_worry
yearly125210273yearly

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 Filter1786911127160.1401276364.3
2DLD Change Limit1127163146.12618399.6
3Display Results3143140.0933376.3
 (SQL Overall)1786913146.35928100.5
 
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.