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

197 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
quartet16281489(None) 
quarte154115321quarte_
quarter163211851quarter
quartes163314931quartes
quartets17277571quartets
quanted1738962quanted
quare143920542quar_e_
quarrel1636092quarrel
quart144027852quar__t
quartan1636422quartan
quartern17286472quartern
quarters173110442quarters
quartette1843962quartette
quartic18258472quartic
quartier1737542quartier
quarto153511122quart_o
quartos16328732quartos
quarts154715932quart_s
quartz244212102quart_z
quartzes2645452quartzes
quate144521412qua_te_
quatre153512352quatre_
quatres163411922quatres
quintet163914452quintet
quirted17369202quirted
aquarist171010083aquarist
armet76739453__armet
artel56122743__artel
aurate64426473aurate_
aurated83817793aurated
barbet104427883_barbet
barret84930483_barret
barter85525373_barter
buret77444013bu_r_et
burnet84326173bu_rnet
caret75360563_car_et
carnet84732873_carnet
carpet104530093_carpet
carte75940423_carte_
carted98631443_carted
cartel85022533_cartel
carter84932273_carter
cartes86239473_cartes
charted135116853charted
charter123918303charter
claret84026573clar_et
curate85226243curate_
curated104717583curated
curates95323823curates
curet75447643cu_r_et
curter85320073cu_rter
curtest9713963cu_rtest
curvet114720243cu_rvet
darted84620923_darted
darter75320363_darter
ecarte84313503ecarte_
ecartes94212563ecartes
equate152012463equa_te_
equated171910403equa_ted
equates162012313equa_tes
farted105121783_farted
garget84327273_garget
garnet73928413_garnet
garret74426553_garret
garter74420513_garter
guarded1036153guarded
guarder936463guarder
gurnet74920873gu_rnet
hearted113314023hearted
hearten102411753hearten
hurter93915853hu_rter
imaret81121233imar_et
market123226043_market
marted94425213_marted
marten84518263_marten
martlet93419153_martlet
parget94529393_parget
parted94228683_parted
partlet92720363_partlet
pearter9412743pearter
peartest10311303peartest
quacked2336793quacked
quadded1934863quadded
quadrant1858083quadrant
quadrat1769273quadrat
quadrate1888043quadrate_
quadrated2055913quadrated
quadrates19117793quadrates
quaere154110673quaere_
quaeres163310833quaeres
quaffed2334253quaffed
quaffer2235133quaffer
quailed1737823quailed
quaint15415173qua_int
quainter1765903quainter
quaintest1845343quaintest
quake184114643qua_ke_
quaked203910033qua_ked
quaker193811623qua_ker
quakes194013343qua_kes
quakier20239203quakier
quakiest2138583quakiest
quale143617853qua_le_
quant143624813qua__nt
quanta153911333quant_a
quantal16367893quantal
quantic18279063quantic
quantity2044733quantity
quants153614143quant_s
quantum1845103quantum
quark184614123quar__k
quarks193810913quar_ks
quarrels1735073quarrels
quarried1836093quarried
quarrier1736843quarrier
quarries1749943quarries
quarry1837463quar_ry
quartans1736283quartans
quartered19155963quartered
quarterer18145713quarterer
quarterly2143693quarterly
quarterns18285143quarterns
quartettes1943793quartettes
quartics19216843quartics
quartiers1845183quartiers
quartile1747043quartile
quartiles1845603quartiles
quartzite2742853quartzite
quashed20207973quashed
quasher19198623quasher
quashes192110973quashes
quasses16209503quasses
quaver18309313qua_ver
qubyte2034243qubyte_
qubytes2134383qubytes
queried1738683queried
querier16310013querier
queries16315873queries
querist16311133querist
quested17168383quested
quester161410023quester
quiet144530733qu__iet
quieted17309723quieted
quieten16258103quieten
quieter162810333quieter
quietest1757173quietest
quillet162713233quillet
quilted17319313quilted
quilter16279803quilter
quinte153414523quinte_
quintes164114713quintes
quintets17347203quintets
quire144917123quir_e_
quired163711943quir_ed
quires154015733quir_es
quirked21325423quirked
quirt144624233quir__t
quirts154213553quirt_s
quite144621463qu_ite_
quitrent1746953quitrent
quitted17339893quitted
quitter162910753quitter
quoited1756403quoited
quote143714773qu_ote_
quoted16359453qu_oted
quoter153510093qu_oter
quotes153312463qu_otes
scarlet91516943scarlet
scarted104816123scarted
smarted105012613smarted
smarten9348863smarten
smarter94113133smarter
smartest10310183smartest
square154513353squar_e_
squared173610553squar_ed
squarer163410653squar_er
squares163714453squar_es
squarest17338213squarest
squatted1835343squatted
squatter1735913squatter
squattest1844613squattest
squirted1845783squirted
squirter1746513squirter
starlet71620123starlet
started84217323started
starter73817873starter
target75028903_target
tarted74923373_tarted
tarter64023563_tarter
tartest72517533_tartest
tartlet72218483_tartlet
turret63121853tu_rret
urate55432163_urate_
urates65027763_urates
urtext1337433_u_rtext
varlet9423503_varlet
warted104223233_warted

Search took 7 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 Filter1786911340270.1561145455.1
2DLD Change Limit1340271976.51620568.9
3Display Results1971970.0762592.1
 (SQL Overall)1786911976.74826480.6
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.