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

108 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
quartern1728648(None) 
quarter163211861quarter_
quarterns18285161quarterns
quarters173110461quarters
quartan1636432quart_an
quarte154115332quarte__
quartered19155972quartered
quarterer18145722quarterer
quartering2045852quartering
quarterly2143712quarterly
quartes163314942quarte_s
quartet162814902quarte_t
quartets17277582quartets
quartier1737552quartier_
quartiers1845192quartiers
artery9911453__artery
astern64815813__astern
barter85525383_barter_
barters94223053_barters
carter84932273_carter_
carters95327263_carters
charter123918303charter_
charters134115593charters
curter85320083cu_rter_
darter75320363_darter_
darters84017613_darters
eastern74412533_eastern
garter74420513_garter_
garters84218253_garters
guarder936463guarder_
guarders1035893guarders
hearten102411763hearte_n
hurter93915853hu_rter_
hurters103413653hu_rters
lantern7310013_lantern
marten84518263_marte_n
pastern94415063_pastern
pattern93712053_pattern
pearter9412743pearter_
quackery2633113quackery
quaere154110683qua__ere
quaffer2235133quaffer_
quaffers2333973quaffers
quainter1765903quainter_
quaker193811623qua_ker_
quakers20309703qua_kers
quakier20239203quakier_
quanted1738973quante_d
quare143920543quar_e__
quarrel1636113quarre_l
quarrels1735093quarrels
quarrier1736853quarrier_
quarriers1845193quarriers
quarry1837473quar__ry
quart144027853quart___
quartans1736293quartans
quarterage2053053quarterage
quarterers19124833quarterers
quarterings2143733quarterings
quartersawn2361603quartersawn
quartette1843973quartette
quartic18258473quart_ic
quartics19216853quartics
quartile1747053quartile
quarto153511123quart__o
quartos16328743quart_os
quarts154715943quart__s
quartz244212103quart__z
quartzes2645463quartzes
quasher19198623quasher_
quashers20186813quashers
quate144521413qua_te__
quatrain1745833quatrain
quatre153512363qua_t_re
quatres163411943quatre_s
quaver18309313qua_ver_
quavers19309023qua_vers
quavery22225483qua_very
querier16310013querier_
queriers1736973queriers
quern143610403qu___ern
quester161410023quester_
questers17168773questers
quieten16258103quiete_n
quieter162810333quieter_
quieters17248743quieters
quilter16279803quilter_
quilters17228443quilters
quirted17369223quirte_d
quitter162910753quitter_
quitters17238533quitters
quoter153510093qu_oter_
quoters16369273qu_oters
saltern74010653_saltern
slattern837093slattern
smarten9348863smarte_n
smarter94113133smarter_
squarer163410663squar_er_
squarers17338033squar_ers
squatter1735913squatter_
squatters1834953squatters
squirter1746523squirter_
squirters1835083squirters
starter73817883starter_
starters83714783starters
subaltern1143243subaltern
tarter64023563_tarter_
tuatera756383tua_tera

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 Filter1786911461620.483369960.7
2DLD Change Limit1461621087.72018932.9
3Display Results1081080.0303600.0
 (SQL Overall)1786911088.23321704.2
 
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.