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
quarterns1828515(None) 
quartern17286471quartern_
quarters173110451quarter_s
quartans1736282quart_ans
quarter163211852quarter__
quartered19155962quartered
quarterer18145712quarterer
quarterers19124822quarterers
quartering2045842quartering
quarterings2143722quarterings
quarterly2143702quarterly
quartes163314932quarte__s
quartets17277572quarte_ts
quartiers1845182quartier_s
barters94223033_barter_s
carters95327253_carter_s
charters134115583charter_s
darters84017603_darter_s
garters84218233_garter_s
guarders1035883guarder_s
heartens113010153hearte_ns
hurters103413643hu_rter_s
lanterns838303_lanterns
martens93714953_marte_ns
pasterns104112623_pasterns
patterns10439943_patterns
quaeres163310843qua__eres
quaffers2333963quaffer_s
quakers20309693qua_ker_s
quarrels1735083quarre_ls
quarriers1845183quarrier_s
quartan1636423quart_an_
quarte154115323quarte___
quarterage2053043quarterage
quarterages2152843quarterages
quarterlies2053653quarterlies
quartet162814893quarte__t
quartette1843963quartette
quartettes1943793quartettes
quartics19216843quart_ics
quartier1737543quartier__
quartiles1845603quartiles
quartos16328733quart__os
quarts154715933quart___s
quartzes2645453quart_zes
quartzous2742013quartzous
quashers20186803quasher_s
quatrains1845583quatrains
quatres163411933qua_t_res
quavers19309013qua_ver_s
queriers1736963querier_s
querns15307943qu___erns
questers17168763quester_s
quietens17246343quiete_ns
quieters17248733quieter_s
quilters17228433quilter_s
quitters17238523quitter_s
quoters16369263qu_oter_s
salterns8388903_salterns
slatterns935363slatterns
smartens10286663smarte_ns
squarers17338023squar_er_s
squatters1834943squatter_s
squirters1835073squirter_s
starters83714773starter_s
subalterns1242223subalterns
tuateras836193tua_teras

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.436409841.7
2DLD Change Limit148641677.31320325.6
3Display Results67670.0302233.3
 (SQL Overall)178691677.77922970.9
 
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.