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

136 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
quartets1727758(None) 
quarters173110461quarters
quartes163314941quarte_s
quartet162814901quartet_
quarrels1735092quarrels
quartans1736292quartans
quarte154115332quarte__
quarter163211862quarte_r
quartern17286482quartern
quarterns18285162quarterns
quartette1843972quartette
quartettes1943802quartettes
quartics19216852quartics
quartiers1845192quartiers
quartos16328742quart_os
quarts154715942quar__ts
quartzes2645462quartzes
quatres163411942quatre_s
quintets17347202quintets
aquarists1856123aquarists
armets84918353__armets
artels66216233__artels
barbets114915843_barbets
barrets94917103_barrets
barters94223053_barters
burets84321263bu_r_ets
burnets93813263bu_rnets
carets85330773_car_ets
carnets93918403_carnets
carpets113915333_carpets
cartels94618123_cartels
carters95327263_carters
cartes86239473_carte_s
charters134115593charters
clarets94111103clar_ets
curates95323833curate_s
curets84922343cu_r_ets
curtest9713963cu_rtest
curvets12399913cu_rvets
darters84017613_darters
ecartes94212563ecarte_s
equates162012323equa_te_s
gargets94614573_gargets
garnets84115413_garnets
garrets84413623_garrets
garters84218253_garters
guarders1035893guarders
gurnets84010793gu_rnets
heartens113010153heartens
hurters103413653hu_rters
imarets9138643imar_ets
markets133314033_markets
martens93714953_martens
martlets103310483_martlets
pargets105215193_pargets
partlets102811523_partlets
peartest10311303peartest
quadrants1965363quadrants
quadrates19117813quadrate_s
quadrats1866483quadrats
quaeres163310853quaere_s
quaffers2333973quaffers
quaintest1845343quaintest
quakers20309703qua_kers
quakes194013343qua_ke_s
quakiest2138583quakiest
quanted1738973quante_d
quantics19276833quantics
quantity2044733quantity
quants153614143qua__nts
quare143920543quar_e__
quarks193810913quar__ks
quarrel1636113quarre_l
quarriers1845193quarriers
quarries1749953quarries
quart144027853quar__t_
quartan1636433quart_an
quartered19155973quartered
quarterer18145723quarterer
quarterers19124833quarterers
quarterly2143713quarterly
quartic18258473quart_ic
quartier1737553quartier
quartile1747053quartile
quartiles1845613quartiles
quarto153511123quar__to
quartz244212103quar__tz
quartzite2742863quartzite
quartzites2842423quartzites
quartzose2751873quartzose
quartzous2742013quartzous
quashers20186813quashers
quashes192110973quashe_s
quasses16209503quasse_s
quate144521413qua_te__
quatre153512363quatre__
quavers19309023qua_vers
qubytes2134383qubyte_s
queriers1736973queriers
queries16315873querie_s
querists1736543querists
questers17168773questers
quietens17246343quietens
quieters17248743quieters
quietest1757173quietest
quiets154014373qu__iets
quillets17256823quillets
quilters17228443quilters
quintes164114713quinte_s
quintet163914453quintet_
quires154015753quir_e_s
quirted17369223quirte_d
quirts154213553quir__ts
quitrents1843893quitrents
quitters17238533quitters
quoters16369273qu_oters
quotes153312463qu_ote_s
scarlets10178573scarlets
smartens10286663smartens
smartest10310183smartest
squarers17338033squar_ers
squares163714463squar_e_s
squarest17338223squar_est
squatters1834953squatters
squattest1844613squattest
squirters1835083squirters
starets73515923star_ets
starlets81610083starlets
starters83714783starters
targets84314223_targets
tartest72517533_tartest
tartlets8289663_tartlets
turrets73010673tu_rrets
urates65027763_urate_s
urtexts1433143_u_rtexts
varlets10411573_varlets

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.406440125.6
2DLD Change Limit1461621366.89321204.4
3Display Results1361360.0462956.5
 (SQL Overall)1786911367.34524328.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.