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

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
quarterlies205365(None) 
quarterages2152842quarterages
arteries8321483__arter_ies
easterlies1046713_easterlies
quackeries2544313quacker_ies
quarries1749943quar__r_ies
quarterage2053043quarterage_
quartered19155963quarter__ed
quarterer18145713quarter__er
quarterers19124823quarter_ers
quartering2045843quarter_ing
quarterings2143723quarterings
quarterly2143703quarterl__y
quarterns18285153quarter__ns
quarters173110453quarter___s
quartettes1943793quarte_ttes
quartiles1845603quart_il_es
afterlifes1643184__afterlifes
afterlives1643554__afterlives
aquarelles1952854aquar_e_lles
barberries1446234_barberries
batteries11615114_batter_ies
bearberries1553464bearberries
butterflies1652654bu_tterflies
butteries11711764bu_tter_ies
cartelise1148114_carte_lise
cartelises1247684_carte_lises
cartelizes2147634_carte_lizes
catteries11815524_catter_ies
cauteries11615394_cauter_ies
currieries1244534currier_ies
curtesies1147524cu_rte_sies
eateries8324314_ea_ter_ies
flatteries1347414flatter_ies
furrieries1343944furrier_ies
martyries1446564_martyr_ies
masteries111018494_master_ies
northerlies1473444_northerlies
nurseries948014nu_rser_ies
orderlies1045454__orderlies
parterres1148054_parter_res
psalteries1276564psalter_ies
quaeres163310844qua__er__es
quandaries2064414quandar_ies
quantifies2244754quant_ifies
quantiles1846604quant_il_es
quantities1946294quant_ities
quarreled1963434quarre_l_ed
quarreler1863244quarre_l_er
quarrelers1962764quarre_lers
quarreling2043664quarre_ling
quarrelled2053154quarre_lled
quarreller1962994quarre_ller
quarrellers2062394quarrellers
quarrelling2143404quarrelling
quarrels1735084quarre_l__s
quarried1836094quar__r_ied
quarrier1736844quar__r_ier
quarriers1845184quar__r_iers
quarter163211854quarter____
quarterback2852004quarterback
quarterbacks2971704quarterbacks
quarterdeck27161914quarterdeck
quarterdecks28151444quarterdecks
quarterfinal2461544quarterfinal
quarterfinals2561314quarterfinals
quartern17286474quarter___n
quartersawed2551174quartersawed
quartersawn2361594quartersawn
quarterstaves2561194quarterstaves
quartes163314934quart____es
quartets17277574quarte___ts
quartette1843964quarte_tte_
quartics19216844quart___ics
quartier1737544quart___ier
quartiers1845184quart___iers
quartile1747044quart_il_e_
quartzes2645454quart___zes
quartzites2842414quart_zites
quaternaries2152834qua_ternaries
quaternion1952534qua_ternion
quaternions2052244qua_ternions
quaternities2152504qua_ternities
quaternity2252744qua_ternity
quatorzes2743124qua_tor_zes
quatrains1845584qua_t_rains
quatrefoils2351254quatrefoils
quatres163411934qua_t_r__es
queries16315874qu___er_ies
sugarberries1552054sugarberries
superlies11314554su__perlies
surgeries10311364su_rger_ies
turneries948494tu_rner_ies
underlies101414204_u_nderlies
wasteries121115344_waster_ies
waterlines1348954_wa_terlines
westerlies1345614_westerlies

Search took 10 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 Filter1786911488190.1731032896.0
2DLD Change Limit148819979.67015389.8
3Display Results97970.0501940.0
 (SQL Overall)178691979.89318062.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.