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 “quarriers” with Change Limit: [1] [2] [3] [4]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

97 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
quarriers184518(None) 
quarrier1736841quarrier_
quarries1749941quarrie_s
quartiers1845181quartiers
barriers104311882_barriers
carriers103614202_carriers
curriers103410752cu_rriers
farriers113610742_farriers
furriers11369492fu_rriers
harriers113712432_harriers
hurriers11358892hu_rriers
marriers103312472_marriers
parriers103612902_parriers
quarrelers1962762quarrelers
quarrels1735082quarr_els
quarried1836092quarrie_d
quarters173110452qua_rters
quartier1737542quartier_
queriers1736962qu_eriers
tarriers83411712_tarriers
arrivers11137003__arrivers
barrier94017733_barrier_
buriers94017193bu__riers
burrers93814493bu_rr_ers
burrier93613553bu_rrier_
carrier93619583_carrier_
carries94328013_carrie_s
charrier1378683charrier_
currier93316703cu_rrier_
curriery13326163cu_rriery
curries93723163cu_rrie_s
durries83817353du_rrie_s
equerries1844883equerrie_s
farrier103514893_farrier_
farriery14295403_farriery
furrier103513663fu_rrier_
furriery14395683fu_rriery
furriners12316323fu_rriners
gharries12318213gharrie_s
guarders1035883gua_rders
gurries83515953gu_rrie_s
harrier104417753_harrier_
harries103525493_harrie_s
hurrier103412943hu_rrier_
hurries103919653hu_rrie_s
marrers93414313_marr_ers
marrieds11288073_marrieds
marrier93817523_marrier_
marries93825283_marrie_s
murries94118673mu_rrie_s
parrier93717653_parrier_
parries93925843_parrie_s
partiers103514243_partiers
quackier23215373quackier_
quadriceps2452393quadriceps
quadrics2045653quadri_cs
quaeres163310843quaer_e_s
quaffers2333963qua_ffers
quaggier1933853quaggier_
quagmires2142303quagmires
quakers20309693qua__kers
quakier20239203qua_kier_
qualifiers2243333qualifiers
qualmier1934563qualmier_
quantizers2842913quantizers
quarrel1636103quarr_e_l
quarreler1863243quarreler_
quarrellers2062393quarrellers
quarryings2371763quarryings
quarter163211853qua_rter_
quarterers19124823quarterers
quartern17286473qua_rtern
quarterns18285153qua_rterns
quartes163314933qua_rte_s
quartets17277573qua_rtets
quartics19216843quarti_cs
quartiles1845603quartiles
quartzes2645453quartze_s
quashers20186803qua_shers
quatres163411933quatr_e_s
quaverers2143853quaverers
quavers19309013qua__vers
querier16310013qu_erier_
queries16315873qu_erie_s
quirkier2134163quirkier_
scarrier10298453scarrier_
sparrier10329143sparrier_
spurriers11245063spurriers
squarers17338023squa_r_ers
starrier8279463starrier_
tarrier74323173_tarrier_
tarries73324263_tarrie_s
tarsiers8298533_tarsiers
terriers84210823_terriers
variers103712663_va_riers
warriors1135363_warriors
worriers11257813_worriers

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 Filter1786911486410.423422437.4
2DLD Change Limit148641977.31320325.6
3Display Results97970.0462108.7
 (SQL Overall)178691977.78222962.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.