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

143 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
quarried183609(None) 
quarrier1736841quarrier
quarries1749941quarries
carried103717152_carried
curried103313652cu_rried
harried113815532_harried
hurried113511042hu_rried
married104715302_married
parried103615722_parried
quarrel1636102quarr_el
quarreled1963432quarreled
quarriers1845182quarriers
quartier1737542quartier
queried1738682qu_eried
tarried83914132_tarried
aeried74221873__aeried
arrived11127353__arrived
barred95725793_barr_ed
barrier94017733_barrier
berried103714053_berried
buried94822373bu__ried
burred95820723bu_rr_ed
burrier93613553bu_rrier
caried94528693_ca_ried
carrier93619583_carrier
carries94328013_carries
charred134614483charr_ed
charrier1378683charrier
curarized2176403curarized
curred94319263cu_rr_ed
currie84317263cu_rrie_
currier93316703cu_rrier
curries93723163cu_rries
durrie73713263du_rrie_
durries83817353du_rries
equerries1844883equerries
farrier103514893_farrier
ferried113411533_ferried
flurried12235283flurried
furred104514433fu_rr_ed
furrier103513663fu_rrier
garred85217413_garr_ed
gharries12318213gharries
gnarred9327013gnarr_ed
guarded1036153gua_rded
gurries83515953gu_rries
harrier104417753_harrier
harries103525493_harries
herried113514463_herried
hurrier103412943hu_rrier
hurries103919653hu_rries
jarred144613253_jarr_ed
juried144212443ju__ried
knarred12266003knarr_ed
marred95421043_marr_ed
marrieds11288073_marrieds
marrier93817523_marrier
marries93825283_marries
murries94118673mu_rries
outcried1139543outcried
parred95024073_parr_ed
parrier93717653_parrier
parries93925843_parries
partied103516553_partied
purred94218073pu_rr_ed
quacked2336793qua_cked
quackier23215373quackier
quadded1934863qua_dded
quadrated2055913quadrated
quadric1946313quadri_c
quadricep2343303quadricep
quadrics2045653quadrics
quadrifid2352903quadrifid
quadriga1944073quadriga
quadruped2262943quadruped
quaere154110673quaer_e_
quaeres163310843quaer_es
quaffed2334253qua_ffed
quaggier1933853quaggier
quailed1737823qua_iled
quaked203910033qua__ked
quakier20239203qua_kier
qualified2245843qualified
qualmier1934563qualmier
quanted1738963qua_nted
quantized2844513quantized
quare143920543qua_r_e_
quarreler1863243quarreler
quarrelled2053153quarrelled
quarrels1735083quarrels
quarry1837473quarr__y
quarrying2273733quarrying
quarrymen2352333quarrymen
quarte154115323qua_rte_
quarter163211853qua_rter
quartered19155963quartered
quartes163314933qua_rtes
quartet162814893qua_rtet
quartic18258473quarti_c
quartics19216843quartics
quartiers1845183quartiers
quartile1747043quartile
quartiles1845603quartiles
quartzes2645453quartzes
quashed20207973qua_shed
quatre153512353quatr_e_
quatres163411933quatr_es
quavered2144813quavered
quayside2143473quayside
queered17117213queer_ed
querier16310013qu_erier
queries16315873qu_eries
quinsied1845043quinsied
quired163711953qu_ir_ed
quirked21325433qu_irked
quirkier2134163quirkier
quirted17369213qu_irted
recarried1244993recarried
remarried1244933remarried
scarred104512633scarr_ed
scarrier10298453scarrier
scurried11267053scurried
serried82513973_serried
slurried9285943slurried
sparred104512863sparr_ed
sparrier10329143sparrier
squared173610563squa_r_ed
starred85013453starr_ed
starrier8279463starrier
tarred74720283_tarr_ed
tarrier74323173_tarrier
tarries73324263_tarries
undried92314613_undried
unharried1344763unharried
unmarried1244583unmarried
untried82615853_untried
updried11226473_updried
varied104817863_va_ried
warred104019843_warr_ed
wearied112911813wea_ried
wherried15175013wherried
whirried15154103whirried
worried11308693_worried

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 Filter1786911461620.436409841.7
2DLD Change Limit1461621437.36019859.0
3Display Results1431430.0632269.8
 (SQL Overall)1786911437.85922737.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.