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

232 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
quarries174994(None) 
quarried1836091quarried
quarrier1736841quarrier
quarriers1845181quarriers
carries94328012_carries
curries93723162cu_rries
durries83817352du_rries
equerries1844882equerries
gharries12318212gharries
gurries83515952gu_rries
harries103525492_harries
hurries103919652hu_rries
marries93825282_marries
murries94118672mu_rries
parries93925842_parries
quadrics2045652quadrics
quaeres163310842quaer_es
quarrel1636102quarr_el
quarrels1735082quarrels
quartes163314932qua_rtes
quartics19216842quartics
quartier1737542quartier
quartiers1845182quartiers
quartiles1845602quartiles
quartzes2645452quartzes
quatres163411932quatr_es
queries16315872qu_eries
tarries73324262_tarries
aeries64737783__aeries
armies85123693__armies
arris56824683__arri_s
arrises71617583__arrises
arrives101311513__arrives
auguries947933auguries
autarkies1344773autarkies
barbies114519593_barbies
barres84427543_barr_es
barrier94017733_barrier
barriers104311883_barriers
barrios9310773_barrios
berries94423553_berries
burdies104117563bu_rdies
buries84633273bu__ries
burnies94017823bu_rnies
burrier93613553bu_rrier
burriest102911213bu_rriest
caries85147623_ca_ries
carnies94123963_carnies
carried103717153_carried
carrier93619583_carrier
carriers103614203_carriers
charlies133414233charlies
charrier1378683charrier
charriest1438263charriest
cherries131812983cherries
claries93422203cla_ries
corries94026803_corries
curacies12311763curacies
curares94916853curar_es
curarines11710553curarines
curaris94114773curari_s
curarizes2078173curarizes
curies84934023cu__ries
currie84317263cu_rrie_
curried103313653cu_rried
currier93316703cu_rrier
curriers103410753cu_rriers
dairies84217733_dairies
darbies104216983_darbies
darkies124015753_darkies
daubries1136743daubries
dearies83526273dea_ries
derries83124623_derries
dhurries1255583dhurries
diaries83321953dia_ries
duperies11312813duperies
durrie73713263du_rrie_
faeries104118993_faeries
fairies103516043_fairies
farcies125317883_farcies
farrier103514893_farrier
farriers113610743_farriers
ferries103521083_ferries
flurries11188913flurries
furies95126373fu__ries
furrier103513663fu_rrier
furriers11369493fu_rriers
furriest112910793fu_rriest
gharris11306433gharri_s
guaranies10127123guaranies
hardies114923233_hardies
harpies123818323_harpies
harried113815533_harried
harrier104417753_harrier
harriers113712433_harriers
hearties11315413hearties
herries104025073_herries
hurdies114015663hu_rdies
hurlies103315333hu_rlies
hurried113511043hu_rried
hurrier103412943hu_rrier
hurriers11358893hu_rriers
jerries143817513_jerries
juries134120633ju__ries
kauries113613193_kauries
kerries113317913_kerries
lorries74518353_lorries
luxuries1544793luxuries
married104715303_married
marrieds11288073_marrieds
marrier93817523_marrier
marriers103312473_marriers
murres85019043mu_rr_es
ouraris73512933ourari_s
outcries10313573outcries
ovaries10312653ova_ries
paries84742513_pa_ries
parried103615723_parried
parrier93717653_parrier
parriers103612903_parriers
parties93230863_parties
perries93226603_perries
prairies10411453prairies
puggries12166383puggries
quackeries2544313quackeries
quackier23215373quackier
quackiest2435183quackiest
quadrans1866363quadrans
quadrates19117803quadrates
quadrats1866483quadrats
quadric1946313quadri_c
quadricep2343303quadricep
quadriceps2452393quadriceps
quadriga1944073quadriga
quadrilles2044763quadrilles
quaere154110673quaer_e_
quaggier1933853quaggier
quaggiest2044173quaggiest
quagmires2142303quagmires
quaiches2235343quaiches
quails153412643qua__ils
quais144618393qua__i_s
quakes194013343qua__kes
quakier20239203qua_kier
quakiest2138583qua_kiest
qualifies2147503qualifies
qualities18311223qualities
qualmier1934563qualmier
qualmiest2044393qualmiest
quandaries2064413quandaries
quantics19276833quantics
quantiles1846603quantiles
quantizes2745713quantizes
quare143920543qua_r_e_
quarks193810913qua_r_ks
quarreled1963433quarreled
quarreler1863243quarreler
quarrelers1962763quarrelers
quarry1837473quarr__y
quarrying2273733quarrying
quarryings2371763quarryings
quarrymen2352333quarrymen
quartans1736283quartans
quarte154115323qua_rte_
quarter163211853qua_rter
quarterlies2053653quarterlies
quarters173110453quarters
quartet162814893qua_rtet
quartets17277573quartets
quartic18258473quarti_c
quartile1747043quartile
quartos16328733qua_rtos
quarts154715933qua_r_ts
quartzites2842413quartzites
quashes192110973qua_shes
quasses16209503qua_sses
quassias1754933quassias
quassins1735793quassins
quatorzes2743133quatorzes
quatrains1845583quatrains
quatre153512353quatr_e_
quayages2144213quayages
quaysides2243283quaysides
queried1738683qu_eried
querier16310013qu_erier
queriers1736963qu_eriers
quickies2336773quickies
quinaries1857873quinaries
quinsies1737623quinsies
quires154015753qu_ir_es
quirkier2134163quirkier
quirkiest2234373quirkiest
qurshes19228573qu_rshes
recarries1147863recarries
remarries1147673remarries
ruderies9311333ruderies
sauries72821623_sauries
scarrier10298453scarrier
scarriest11188403scarriest
scurries102911483scurries
serries73925353_serries
sharpies13411233sharpies
sherries111812893sherries
skerries12168673skerries
slurries82710413slurries
smarties10312873smarties
sparrier10329143sparrier
sparriest11198793sparriest
spurries102311323spurries
squares163714463squa_r_es
squarrose1842393squarrose
starrier8279463starrier
starriest9159773starriest
sudaries9312753sudaries
sundries9312023sundries
tardies84225863_tardies
tarres64723043_tarr_es
tarried83914133_tarried
tarrier74323173_tarrier
tarriers83411713_tarriers
tarriest83215003_tarriest
terries73425633_terries
updries10209083_updries
urares64519093_urar_es
uraris63817273_urari_s
usuries7510633_usuries
varies94330873_va_ries
wearies103020223wea_ries
wherries14179023wherries
whirries14136693whirries
worries104117133_worries
yearlies1137603yearlies

Search took 9 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 Filter1786911461620.410435831.7
2DLD Change Limit1461622327.98318309.2
3Display Results2322320.0763052.6
 (SQL Overall)1786912328.46921099.4
 
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.