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
quartern1728647(None) 
quarter163211851quarter_
quarterns18285151quarterns
quarters173110451quarters
quartan1636422quart_an
quarte154115322quarte__
quartered19155962quartered
quarterer18145712quarterer
quartering2045842quartering
quarterly2143702quarterly
quartes163314932quarte_s
quartet162814892quarte_t
quartets17277572quartets
quartier1737542quartier_
quartiers1845182quartiers
artery9911453__artery
astern64815813__astern
barter85525373_barter_
barters94223033_barters
carter84932273_carter_
carters95327253_carters
charter123918303charter_
charters134115583charters
curter85320083cu_rter_
darter75320363_darter_
darters84017603_darters
eastern74412533_eastern
garter74420513_garter_
garters84218233_garters
guarder936463guarder_
guarders1035883guarders
hearten102411753hearte_n
hurter93915853hu_rter_
hurters103413643hu_rters
lantern7310013_lantern
marten84518263_marte_n
pastern94415063_pastern
pattern93712053_pattern
pearter9412743pearter_
quackery2633113quackery
quaere154110673qua__ere
quaffer2235133quaffer_
quaffers2333963quaffers
quainter1765903quainter_
quaker193811623qua_ker_
quakers20309693qua_kers
quakier20239203quakier_
quanted1738963quante_d
quare143920543quar_e__
quarrel1636103quarre_l
quarrels1735083quarrels
quarrier1736843quarrier_
quarriers1845183quarriers
quarry1837473quar__ry
quart144027853quart___
quartans1736283quartans
quarterage2053043quarterage
quarterers19124823quarterers
quarterings2143723quarterings
quartersawn2361593quartersawn
quartette1843963quartette
quartic18258473quart_ic
quartics19216843quartics
quartile1747043quartile
quarto153511123quart__o
quartos16328733quart_os
quarts154715933quart__s
quartz244212103quart__z
quartzes2645453quartzes
quasher19198623quasher_
quashers20186803quashers
quate144521413qua_te__
quatrain1745823quatrain
quatre153512353qua_t_re
quatres163411933quatre_s
quaver18309313qua_ver_
quavers19309013qua_vers
quavery22225483qua_very
querier16310013querier_
queriers1736963queriers
quern143610403qu___ern
quester161410023quester_
questers17168763questers
quieten16258103quiete_n
quieter162810333quieter_
quieters17248733quieters
quilter16279803quilter_
quilters17228433quilters
quirted17369213quirte_d
quitter162910753quitter_
quitters17238523quitters
quoter153510093qu_oter_
quoters16369263qu_oters
saltern74010653_saltern
slattern837093slattern
smarten9348863smarte_n
smarter94113133smarter_
squarer163410663squar_er_
squarers17338023squar_ers
squatter1735913squatter_
squatters1834943squatters
squirter1746523squirter_
squirters1835073squirters
starter73817883starter_
starters83714773starters
subaltern1143243subaltern
tarter64023563_tarter_
tuatera756373tua_tera

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 Filter1786911461620.420425454.8
2DLD Change Limit1461621086.89021213.6
3Display Results1081080.0502160.0
 (SQL Overall)1786911087.36024278.7
 
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.