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

67 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
quarterns1828516(None) 
quartern17286481quartern_
quarters173110461quarter_s
quartans1736292quart_ans
quarter163211862quarter__
quartered19155972quartered
quarterer18145722quarterer
quarterers19124832quarterers
quartering2045852quartering
quarterings2143732quarterings
quarterly2143712quarterly
quartes163314942quarte__s
quartets17277582quarte_ts
quartiers1845192quartier_s
barters94223053_barter_s
carters95327263_carter_s
charters134115593charter_s
darters84017613_darter_s
garters84218253_garter_s
guarders1035893guarder_s
heartens113010153hearte_ns
hurters103413653hu_rter_s
lanterns838303_lanterns
martens93714953_marte_ns
pasterns104112623_pasterns
patterns10439943_patterns
quaeres163310853qua__eres
quaffers2333973quaffer_s
quakers20309703qua_ker_s
quarrels1735093quarre_ls
quarriers1845193quarrier_s
quartan1636433quart_an_
quarte154115333quarte___
quarterage2053053quarterage
quarterages2152853quarterages
quarterlies2053663quarterlies
quartet162814903quarte__t
quartette1843973quartette
quartettes1943803quartettes
quartics19216853quart_ics
quartier1737553quartier__
quartiles1845613quartiles
quartos16328743quart__os
quarts154715943quart___s
quartzes2645463quart_zes
quartzous2742013quartzous
quashers20186813quasher_s
quatrains1845593quatrains
quatres163411943qua_t_res
quavers19309023qua_ver_s
queriers1736973querier_s
querns15307943qu___erns
questers17168773quester_s
quietens17246343quiete_ns
quieters17248743quieter_s
quilters17228443quilter_s
quitters17238533quitter_s
quoters16369273qu_oter_s
salterns8388903_salterns
slatterns935363slatterns
smartens10286663smarte_ns
squarers17338033squar_er_s
squatters1834953squatter_s
squirters1835083squirter_s
starters83714783starter_s
subalterns1242223subalterns
tuateras836203tua_teras

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 Filter1786911486410.453394461.4
2DLD Change Limit148641678.12318298.8
3Display Results67670.0332030.3
 (SQL Overall)178691678.60920756.3
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.